Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
KarenFingerhut
Post Patron
Post Patron

Matrix Format Changes WShen No Data Present

Matrix with No DataMatrix with No DataFields Included in MatrixFields Included in MatrixMatrix with dataMatrix 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

 

 

1 ACCEPTED SOLUTION
v-eachen-msft
Community Support
Community Support

Hi @KarenFingerhut ,

 

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

 

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.

View solution in original post

3 REPLIES 3
v-eachen-msft
Community Support
Community Support

Hi @KarenFingerhut ,

 

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

 

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.

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

 

Thank you

K

Thank you, ill give that a whirl

 

Regards

Karen

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors