Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi,
i've a graph with hours on X-axis.
i'm looking for the way to fix range on 00:00 to 24:00 even if there no data between 00:00 et 07:00 for example.
on my graph the axis changes depending on the datas :
Thanks !
Hello @mhossain ,
thanks for your proposal, but unfortunately, i don't want to have values = to 0.
Maybe have i to create a table with hours ?
Is that what you suggest when you say :
I guess, hours on the x axis coming from some mapping table and you have 0 to 24:00 all hours.
Hello @GeekAlfPro
Yes, mapping table is required with all the hours.
So for the hours you don't have value what do you want to show?
yes, that's it, for some items, i have values for others, not.
that's why i want to fix the scale of hours.
i created a time table, but without success.
I guess, hours on the x axis coming from some mapping table and you have 0 to 24:00 all hours.
In the measure for the value you can add IF(ISBLANK(measure),0,measure).
Hope above helps.
You can share the dummy pbix if above is not clear.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
89 | |
82 | |
76 | |
64 |
User | Count |
---|---|
142 | |
111 | |
108 | |
99 | |
95 |