Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi I have two clustered columns I want to display one below each other. These show total values for each hour.
However, if an hour doesn't have data, it doesn't show that hour.
For example, graph 1 might only have data from 06:00 to 21:00. Graph data has data from 00:00 to 23:00.
But I want both graphs to display all 24 hours in the day.
Is there anyway I can set the X-axis to display the 24 hours of the day, so you can compare the two graphs? I've tried "Show items with no data" but that's not working.
Thanks
Solved! Go to Solution.
Hi @Anonymous
You need create a new table with a column which is listing 0-24 hour, and then manage the relationship between your fact table.
Then you can use the new column added above as X axis, and enable the "Show items with no data", I believe you can work it out!
Hi @Anonymous
You need create a new table with a column which is listing 0-24 hour, and then manage the relationship between your fact table.
Then you can use the new column added above as X axis, and enable the "Show items with no data", I believe you can work it out!
@Anonymous Try:
Measure =
VAR __Calc = <some calc>
RETURN
__Calc+0
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
78 | |
75 | |
50 |
User | Count |
---|---|
144 | |
109 | |
108 | |
87 | |
61 |