Forum Discussion

ferdiakinci's avatar
ferdiakinci
Frequent Visitor
2 years ago

matrix hide

There is a matrix where I bring foreign currency based amounts. If all columns are empty, the matrix should not display. how can I do that
Need Help
rajendraongole1's avatar
rajendraongole1
Super User
2 years ago

Hi ferdiakinci - you can achieve this with combination of flag measure and conditional formatting. 

Create a calculated column as below:

replace with your important metrics in below table and columns.

 

CheckEmptyColumns_m =
IF(
    ISBLANK(
        SUM('Sales'[Sales Amount]) +
        SUM('Sales'[Target Sales]) +
        SUM('Sales'[Cumulative Sales])),1,0)

 

Now set the conditional formatting on background based on the  checkemptycolumn_m measure. you can display the title as "Data Available" when the measure is 0 and "No Data" when the measure is 1.

 

Hope it helps

 

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

 

  • ferdiakinci's avatar
    ferdiakinci
    Frequent Visitor
    2 years ago

    Thank you for your help. This doesn't work for me. What I want to do is to make the table not appear at all when it is empty.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Thanks for the reply from rajendraongole1 , please allow me to provide another insight:

      Hi, ferdiakinci .

      Thanks for letting us know your user experience.  According to your case description, I do understand how frustrated you are now.If you need to disappear when the matrix value is empty, you can't do that at the moment.

       

      But you can try the following alternatives:

      1.First, create a bookmark, and when the data is empty, manually click on the page that goes to no visualization.

       

      The following is the relevant documentation, I hope it will be helpful to you:

      Create report bookmarks in Power BI to share insights and build stories - Power BI | Microsoft Learn
       

      2.Second, you can choose to duplicate the page, delete the visualization, and switch manually.

       

      The following are the documents for creating page and bookmark navigation, I hope it will help you:
      Create page and bookmark navigators - Power BI | Microsoft Learn

       

      If you feel that performance needs to be improved, you can also submit an idea on

      https://ideas.fabric.microsoft.com/ and wait for users with the same needs as you to vote for you and help you realize the idea as soon as possible. Many features of our current products are designed and upgraded bed on customers’ feedback.  With requirements like this increase, the problem may well be released in the future.

       

      Thanks for your understanding.

       

      Best Regards,

      Leroy Lu

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.