Matrix Format Changes WShen No Data Present

[KarenFingerhut]

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

[v-eachen-msft · Accepted solution]

Hi @KarenFingerhut ，

You could add "Suit For View Flag" in the filter pane, and set the rule as the image.

[KarenFingerhut]

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

Thank you

K

[KarenFingerhut]

Thank you, ill give that a whirl

Regards

Karen