Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Power BI filtering issues in matrix

Matrix in the Power BI will be filtered based on the month selected (Left side visual). When selected January, in matrix, on expanding the Location R100, there are values for Jan 06, Jan 27 which is ...
Need Help
  • v-xuding-msft's avatar
    v-xuding-msft
    6 years ago

    Hi Anonymous ,

     

    Please try to add a visual filter in Filter Pane like this:

     

    Measure = 
VAR COUNT_ =
    CALCULATE ( DISTINCTCOUNT ( FactJobClubOrientation[RosterID] ) )
RETURN
            IF ( ISBLANK ( COUNT_ ), 0, COUNT_ )

     

     

     

DataMozart's avatar
DataMozart
Frequent Visitor
6 years ago

Hi vamsikrishna007,

 

As you wrote: I can’t replace the 0 in DAX with blank or null because as per the business i have to display 0 in Power BI...

 

0 is a value, same as 1, 10, 100... so if you intentionally put it in your DAX measure instead of BLANK, then there is no way that you don't display it, as long as you use "regular" date dimension with contiguous dates in it. 

 

The only way to hide those rows is to use filters and choose to display only those values of the measure > 0.

 

Hope that this helps.