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 functions.

Show and Tell
Tips and Tricks

5 Replies

  • 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