Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Page navigation through Dax function

when data is available on the page then the navigation button should be green. when data is not available on the page then the navigation button should be red. I need help and how to apply using DAX ...
Show and Tell
Tips and Tricks
Hariharan_R's avatar
Hariharan_R
Solution Sage
4 years ago

Hi

You can get minimally with below expression.

 

Button Color = IF(ISEMPTY('Table'),"Red","Green")

 

Thanks

Hari

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

My Blog :: YouTube Channel :: My Linkedin


 
Anonymous's avatar
Anonymous
Not applicable
4 years ago

I tried on my power bi desktop, but it's not working, please help me with another function that can be applied.

if the above function is working then how?

 

  • Hariharan_R's avatar
    Hariharan_R
    Solution Sage
    4 years ago

    Hi,

    You need to display the button based on data availability. I am not sure what kind of slicers and filters are there so considered a table. if the table is empty then visuals using the table is empty. 

     

    In the above script, you need to replace 'Table' with your table name. Share us the detailed information to provide correct expression.

     

    Thanks

    Hari

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi,

       

      suppose I have excel data and connected to power bi and applied if(isempty(table),"Red","Green") function on-page navigation button, now testing the data, if deleted some columns from excel table or deleted entire data except header. Its showing green both the condition, when deleted the columns from table, visual will disappear but button is green. When I again put data in table and showing same (green-button). So, please suggest me.

       

      Thanks,

      Dharmendra