Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have a clustered column chart that display monthly data, however some data are not yet being input. I'd like those empty month to show the value 0. Something like this :
Is there any solution to this?
Solved! Go to Solution.
You have to define that in your measure, considering you are taking sum in columnA and want to show 0 when its blank
Measure = IF(ISBLANK(Sum(columnA)), 0, Sum(columnA))
If this post helps, then please consider Accept it as the solution and give it a thumbs up
You have to define that in your measure, considering you are taking sum in columnA and want to show 0 when its blank
Measure = IF(ISBLANK(Sum(columnA)), 0, Sum(columnA))
If this post helps, then please consider Accept it as the solution and give it a thumbs up
User | Count |
---|---|
65 | |
27 | |
25 | |
17 | |
11 |