Forum Discussion
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
Hi KarenFingerhut ,
You could add "Suit For View Flag" in the filter pane, and set the rule as the image.
3 Replies
- v-eachen-msftCommunity Support
Hi KarenFingerhut ,
You could add "Suit For View Flag" in the filter pane, and set the rule as the image.
- KarenFingerhutResponsive Resident
Thank you, ill give that a whirl
Regards
Karen
- KarenFingerhutResponsive Resident
I think that might have done the trick :) Ill drop more data in and see if it works again
Thank you
K