Forum Discussion
Hide blank values in hierarchy matrix
Hi , iLoveTea
According to your image, we can not make this measure return 1 and 0 and then filter it.
I test this method before,it dose not work the same as yours.
The method should return the value you need, you need to update this measure return teh value which this column need.And you need to replace all the column by the measures.
That means you need to create two measures like that to replace this two yellow columns.You need to replace the 1 to your need value in the measure .
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Community SupportHi , iLoveTea
According to your description, you want to "Hide blank values in hierarchy matrix". Right?
Here is a method you can refer to :
(1)This is my test data:
(2)We can create a measure to replace the value in your visual:
Replace sum of value = IF( ISINSCOPE('Table'[Type1])&& SELECTEDVALUE('Table'[Type1])=BLANK(),BLANK(),IF(ISINSCOPE('Table'[Type2])&& SELECTEDVALUE('Table'[Type2])=BLANK(),BLANK(),IF(ISINSCOPE('Table'[Type3])&&SELECTEDVALUE('Table'[Type3])=BLANK(),BLANK(),IF(ISINSCOPE('Table'[Type4])&& SELECTEDVALUE('Table'[Type4])=BLANK(),BLANK(),SUM('Table'[Value])))))(3)Then we can put the field on the visual :
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hey, let's move one step forward to this problem. I was getting the same problem and had it solved with this measure. But now, when I export the data to excel some of the rows are filtering out. No, visual level filter is applied. Even when I convert the matrix to a table visual the values are getting filtered out. Any help will be appreciated.
Hi Aniya Zhang
is there any solution to achieve this in slicer to remove blanks in sub level without impact on parent levels
Thanks
Govardhan Koppala
