Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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))