Forum Discussion

KarenFingerhut's avatar
KarenFingerhut
Responsive Resident
6 years ago
Solved

Matrix Format Changes WShen No Data Present

Matrix with No DataFields Included in MatrixMatrix with data

 

Hi there

 

Please see Pictures above and detail below

 

In a nutshell what is happening is if there is no data to show in the matrix the format of it changes.

 

Below is the DAX expresssion I used

Suit For View Fix = IF(UsingNewCodes[Suit For View Flag] = 1, "Suit For View", "N/A")

 

The issue I have is if there is no data to show the format of the Matrix.What I would like to see is if there is no data present it returns a blank

 

Can someone please advise to (if possibole) remedy this.

 

Thank you

 

Many thanks

Karen

 

 

3 Replies

    • KarenFingerhut's avatar
      KarenFingerhut
      Responsive Resident

      I think that might have done the trick :) Ill drop more data in and see if it works again

       

      Thank you

      K