topic Re: Page navigation through Dax function in Developer

Page navigation through Dax function

Anonymous — Thu, 16 Jun 2022 10:28:28 GMT

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.

Re: Page navigation through Dax function

Hariharan_R — Thu, 16 Jun 2022 11:26:46 GMT

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

Re: Page navigation through Dax function

Anonymous — Thu, 16 Jun 2022 11:58:23 GMT

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?

Re: Page navigation through Dax function

Hariharan_R — Thu, 16 Jun 2022 12:02:44 GMT

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

Re: Page navigation through Dax function

Anonymous — Thu, 16 Jun 2022 12:29:54 GMT

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

Re: Page navigation through Dax function

Anonymous — Thu, 16 Jun 2022 12:55:15 GMT

Hi,

Thanks,

Dharmendra