Forum Discussion
yodha
Helper IV
Helper IVFilter zeros from Power BI Matrix
Hi,
In my .pbix i have a matrix like this,
in this matrix, 1. i have to filter/hide "0"s (Yellow color ones) in "available" column
2. and then i have to replace "0"s (blue color ones) in used, current columns with BLANK.
and my final matrix should be visible like this,
Any help on this?
Thanks in advance.
Hi yodha ,
First go to query editor,filter on column "available",choosing Does not equal 0;
Then create 2 measures as below:
_current = IF(MAX('Table'[current])=0,BLANK(),MAX('Table'[current]))_used = IF(MAX('Table'[used ])=0,BLANK(),MAX('Table'[used ]))Finally you will see:
For the related .pbix file,pls click here.
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
6 Replies
v-kelly-msftCommunity Support
Hi yodha ,
First go to query editor,filter on column "available",choosing Does not equal 0;
Then create 2 measures as below:
_current = IF(MAX('Table'[current])=0,BLANK(),MAX('Table'[current]))_used = IF(MAX('Table'[used ])=0,BLANK(),MAX('Table'[used ]))Finally you will see:
For the related .pbix file,pls click here.
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
yodhav-kelly-msft Thank you so much
