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