Skip to main content
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
melf123
New Contributor

how to group columns by date and time without each time popping up on chart

Hi everyone,

I'm trying to group the number of 'Releases' in the Release column by placing it in the Y axis, but I'd like these to be grouped by their scheduled date and their scheduled time.

I'm trying to do this by placing the 'Scheduled Date' and 'Time' columns in the X axis, but I don't want each time to show in the X-axis. Is there a way to hide these from displaying but still have it affect the chart? I just want the X axis to show the months and year, while still taking the time into account without making the chart this messy. That's why I'm hoping to find a way to hide this from the X axis while still applying it to the grouping.

Screenshot example below.

melf123_0-1699321087480.png

 

1 REPLY 1
lbendlin
Esteemed Contributor III

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

Helpful resources

Announcements
Users online (3,586)