Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Anonymous
Not applicable

Conditional Formatting of Button Tooltips

Hi, On the buttons used for Page navigation there is an option to condinally format the tooltip. I am looking for a way to dynamically show a tooltip on each button to indicate which Page it's going to navigate to, but not quite able to figure out how to assign Page name using DAX. I have created a DAX datatable with Index and names of report pages. I want to achieve something like this in the measure used by the button tooltip:

Report Page Button Tooltip =
SWITCH("What Criteria to use?",
"Report Page 1", "Now showing Report Page 1...",
"Report Page 2", "Now showing Report Page 2...",
""
)
Is something like this possible?
1 ACCEPTED SOLUTION
v-janeyg-msft
Community Support
Community Support

Hi, @Anonymous 

 

I don't understand what the dynamic you want is. First of all, the page name can't be automatically displayed by any dax function, you must name it directly if you want to use it. 

vjaneygmsft_0-1631687565544.png

Secondly, if you use the button to jump to other pages, isn't it fixed? Why do you need dynamic?


Best Regards,

Community Support Team _ Janey

View solution in original post

4 REPLIES 4
v-janeyg-msft
Community Support
Community Support

Hi, @Anonymous 

 

I don't understand what the dynamic you want is. First of all, the page name can't be automatically displayed by any dax function, you must name it directly if you want to use it. 

vjaneygmsft_0-1631687565544.png

Secondly, if you use the button to jump to other pages, isn't it fixed? Why do you need dynamic?


Best Regards,

Community Support Team _ Janey

Anonymous
Not applicable

Hi @v-janeyg-msft I think you said it right "First of all, the page name can't be automatically displayed by any dax function,". May be what I think is not possible. Thanks for the replies. 

amitchandak
Super User
Super User

@Anonymous , If should be selectedpage  name 

 

Report Page Button Tooltip =
SWITCH(selectedvalues(Page[PageName]) ,
"Report Page 1", "Now showing Report Page 1...",
"Report Page 2", "Now showing Report Page 2...",
""
)

 

 

Same formula that you use in action, you should use in the tooltip

 

refer if needed

Display only one page in the report, Hide rest: https://youtu.be/d4H0GKUH0r4

 

Anonymous
Not applicable

Thanks @amitchandak for quick reply. I am wondering however that how to do conditional navigation first of the pages using Report Page name? I have a datatable like this. Typically you would use some rules based on the data or in the past I have used USERNAME() function to restrict the page navigation for certain users. In this case however, I am bit lost as to how first achieve dynamic page navigation using page names, (and then I guess the same logic will apply to button tooltips)? I have added buttons with Text on them as "1", "2", "3" and so on...

 

 

Page_Datatable =
DATATABLE (
    "Sr No", INTEGER,
    "Report Page", STRING,
    {
        { 1, "Report Page 1" },
        { 2, "Report Page 2" }
    }
)

 

 

 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.