Forum Discussion
Helper IIShowing Filtered Values and Blanks
Hi Otto_Luvpuppy ,
I created some data:
When the value is blank, Power BI automatically hides the value that is blank:：
The first method:
You can check [status] – Show items with no data.
A blank value is then displayed：
The second method:
You can create a Measure and replace Blank with 0.
Create measure：
Measure 2 = IF( [Measure] = BLANK() ,0,[Measure])If you need pbix, please click here.
Showing Filtered Values and Blanks.pbix
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi Otto_Luvpuppy ,
I created some data:
When the value is blank, Power BI automatically hides the value that is blank:：
The first method:
You can check [status] – Show items with no data.
A blank value is then displayed：
The second method:
You can create a Measure and replace Blank with 0.
Create measure：
Measure 2 =
IF(
[Measure] = BLANK() ,0,[Measure])
If you need pbix, please click here.
Showing Filtered Values and Blanks.pbix
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Helper IIHi...thanks for the reply. I already had the 1st method on and funnily enough I'd plugged the second method in shortly after I posted this call for help.....that seems to work.
Thanks again