Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
Hallo,
my question is:
I have a report with several pages and on the first page (start page) there are text fields as buttons that link to the other pages. On the other pages are tables with values. But the tables do not always contain values.
Now I want that if in a table values are contained the button on the start page is displayed in green.
Does anyone have an idea ?
Thank youdfd
Solved! Go to Solution.
Hi @Anonymous ,
You may need to firstly define which pages on the Table visual has no value, and then use Conditioanl Formatting on Background color:
Navigate button = SWITCH(MAX('Page Name'[Value]),"Overview","Green","District Monthly Sales","Red","New Stores","Yellow")
Create buttons in Power BI reports - Power BI | Microsoft Docs
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
You may need to firstly define which pages on the Table visual has no value, and then use Conditioanl Formatting on Background color:
Navigate button = SWITCH(MAX('Page Name'[Value]),"Overview","Green","District Monthly Sales","Red","New Stores","Yellow")
Create buttons in Power BI reports - Power BI | Microsoft Docs
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
page navigation buttons
User | Count |
---|---|
105 | |
69 | |
48 | |
47 | |
47 |