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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.