Dynamic page title based on slicer selection in Power BI Report

[satishorre20]

Greetings,

I am just checking and see if there is any option to append to page title/header based on slicer selection using VALUES(slicer) and HASONEVALUE DAX Functions.

I have created DAX measure and wanted to use this measure in the page header. page header/title like " Sales Trends in Multiple Projects(s)" if user selected more than 2 values from slicer.  "Multiple" is derived from measure based on slicer selection.

Project List = 
var  _cnt = COUNTROWS( values(slicer column/attribute))
var   _names = IF ( _cnt <=2, CONCATENATEX(VALUES(slicer column/attribute), slicer column/attribute, ",", slicer column/attribute, ASC), "Multiple")
RETUNR
  _names

Any thoughts to create Dynamic page title ( not visualization title)?

[Anonymous]

Hi @satishorre20 ,

Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.

If these also don't help, please share more detailed information and description to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[Anonymous]

HI @satishorre20,

Any update on this? Did the above suggestion help for your scenario?

Regards,

Xiaoxin Sheng

[rohit1991]

Hi @satishorre20 ,
Yes, you can create a dynamic page title based on slicer selection using a DAX measure and a Card visual in Power BI. While Power BI does not allow direct modification of the actual report page title dynamically, you can achieve a similar effect by displaying a dynamic title in a Card visual at the top of the page. To do this, you can create a measure that evaluates the selected slicer values and constructs a title accordingly. A refined version of your measure would be:

DynamicPageTitle = 
VAR _cnt = COUNTROWS(VALUES('Table'[SlicerColumn]))
VAR _names = 
    IF(
        _cnt <= 2, 
        CONCATENATEX(VALUES('Table'[SlicerColumn]), 'Table'[SlicerColumn], ", "),
        "Multiple Projects"
    )
RETURN 
    "Sales Trends in " & _names

This measure checks the number of selected values from the slicer. If one or two values are selected, it concatenates them into a readable string; otherwise, it returns "Multiple Projects" to indicate a broader selection. To implement this, add a Card visual to the report, set its value to this measure, and format it as a page header by adjusting the font, size, and position to make it visually resemble a title. While this does not change the actual page/tab name in Power BI, it serves as an effective workaround to reflect dynamic titles based on user selections.

[tharunkumarRTK]

@satishorre20 

If you are referring to changing the report page dynamically then as @danextian mentioned, its not possible. 

I case if you want to change the Text/Shapre/Blank button element that you have used as a report page title/header then its possible 

For example, insert a blank button on the report canvas and under format setttings you will find "Style" -> "Text"

there you will find "Fx" button, click on it and you will be able to select the DAX measure you created for the dynamic title logic 

Hope that answers your question

Need a Power BI Consultation? Hire me on Upwork

Connect on LinkedIn

Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!

[danextian]

Hi @satishorre20 

If you're referring to the name of a page, that isn't possible. You can't configure page names with DAX.

[speedramps]

You can not dynamivcal change the page name but you can create dynamic measure and display it in a card at ten top of page, so it looks like a page heading.

For example ...

Heading = 
var mytext =
SWITCH(DISTINCTCOUNT(yourdata[Country]),
1, SELECTEDVALUE(yourdata[Country]),
2, 
CONCATENATEX ( 
        FILTERS ( yourdata[Country] ),
        yourdata[Country] , 
        " and " ),
 "Multiple"        
)
RETURN
    "Page heading is " & mytext

Please click thumbs up and accept solution, thank you