Page navigation through Dax function

[Anonymous]

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.

[Anonymous]

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

[Hariharan_R]

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]

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]

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]

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