Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Removing Blank Row From the Matrix table

Hi,  I would like to remove blank row from the Matrix Table. The challange i have is the table data is from two different database. Please suggest me if I can use any dax to hide the blank row. Be...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

    Please have a try.

    You can just add in Visual Filters of that Visual, as "is not blank".

     

    That would satisy your requirement. 

     

     

    Best Regards

    Community Support Team _ Polly

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , Ideally speaking, a blank row should not come, Have you handled blank value in Metric 1, Metric 2 or Metric 3?

 

Or have used option "Show Item with no data" ?

 

 

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Show items with no data isn't working. Those are measures and database value's.