Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi
I am trying to create a bar chart where in for some of the weeks/months there is no data however, I would like to display 0 instead of blank. Please help if there any options or workaround.
Thanks,
Krishna.
Solved! Go to Solution.
Hi @Anonymous ,
In the column chart zero would be no column in the x-axis.
If you just want to show 0 as lable as well as the other column, then you could create a formula and add +0 at the end of it.
Measure = SUM('Table'[Column2])+0
Best Regards,
Jay
Hi @Anonymous ,
In the column chart zero would be no column in the x-axis.
If you just want to show 0 as lable as well as the other column, then you could create a formula and add +0 at the end of it.
Measure = SUM('Table'[Column2])+0
Best Regards,
Jay
@Anonymous , +0 in measure can help , but it will show all dates , Try like this example
0 between range
new Measure = var _1= [measure]+0
var _min = minx(ALLSELECTED('Calendar'), 'Calendar'[Date])
var _max = maxx(ALLSELECTED('Calendar'), 'Calendar'[Date])
return
CALCULATE(if(max('Calendar'[Date]) <_min || max('Calendar'[Date]) >_max , BLANK(), _1))
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
92 | |
83 | |
62 | |
61 | |
58 |
User | Count |
---|---|
157 | |
118 | |
103 | |
76 | |
66 |