Forum Discussion
Matrix Visualization - Suppress Zero and Missing Rows
Hi,
I am currently using a Matrix Visualization, I want Suppress Zero and Missing Rows?
Currently all the Rows are showing because of the way the DAX Measure is being calculated and cannot think of an alternative way to deal with this.
Basically I want those Rows to be grouped as blank or Null and appear on the Visuzalization, is this possible?
Thanks
5 Replies
- AnonymousNot applicable
HI AvPowerBI
Can you please provide more info with screenshots, input and required output in table format for the community so that you ask can be better understood and resolved quickly.
from what I understand, I would use
Visual Control = var _result = CALCULATE( SUM('Table'[Value]), ALLEXCEPT('Table','Table'[Category]) ) return IF( _result>0, 1,0 )Then,
- amitchandakSuper User
AvPowerBI , not very clear. Try measure like
if([measure] =0 , blank(), [measure])
if(calculate([measure]) ,allexcept(Table,Table[row])) =0, blank(), [measure]) // row is column on row.
- v-easonf-msftCommunity Support
Hi, AvPowerBI
Could you please share relevant screenshots to further elaborate on your question?
Best Regards,
Community Support Team _ Eason - Greg_DecklerCommunity Champion
AvPowerBI - Perhaps something like:
Measure = VAR __Calc = <some calculation> RETURN IF(__Calc = 0,BLANK(),__Calc)Make sure that "Show items with no data" is not turned on anywhere.
Otherwise, Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2. - v-easonf-msftCommunity Support
Hi, AvPowerBI
Could you please tell me whether your problem has been solved?
For now, there is no content of description in the thread.
Best Regards,
Community Support Team _ Eason