cancel
Showing results for 
Search instead for 
Did you mean: 
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
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.