Matrix No data

[prasoonY]

I want to display a message like “No record found” when your matrix in Power BI doesn’t have any data.

[prasoonY]

 i can't find it in the matrix visual @123abc 

[123abc]

To display a message like "No record found" when your matrix in Power BI doesn't have any data, you can use the "No data" option available in Power BI. Here's how you can do it:

1. Open your Power BI report and select the matrix visual for which you want to display the "No record found" message.

2. In the Visualizations pane on the right-hand side, click on the matrix visual to select it.

3. In the Format section of the Visualizations pane, expand the "No data" section.

4. Turn on the "No data" option by toggling the switch to the "On" position.

5. You can now enter the message you want to display when there's no data in the matrix. In your case, you can enter "No record found" in the provided text box.

6. Customize the formatting of the message by adjusting the font size, font color, or background color if needed.

7. Once you've configured the "No data" message to your liking, close the Format section.

Now, when there is no data to display in the matrix visual, Power BI will show the message "No record found" in the center of the visual. When data is available, this message will automatically disappear.

This feature is helpful for providing context to users when there's no data to display in a visual, ensuring that they understand why there are no records shown.

[Idrissshatila]

@123abc , can you please show us a screenshot for the no data section you've mentioned, because i can't find it in the matrix visual.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡