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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
melf123
Frequent Visitor

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
Super User
Super User

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
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

Top Solution Authors