Need Help with Dynamic Card Titles Based on Slicer Selection in Power BI

[Anonymous]

Hey 
Good people of Power Community ! 
Is there anyone who can actually help me on this ?

I am actually facing an issue, where measures used in tooltips (S% and NR%) are unintentionally being appended to the dynamic titles of my cards. This occurs when switching titles between "Net Revenue by Partner" and "Sales by Partner" via a slicer selection.

Detailed Problem Description:

• Expected Behavior: Each card should display "Net Revenue by Partner" or "Sales by Partner" as its title based on the slicer selection.
• Actual Behavior: Along with switching titles, the card titles are appended with S% and NR%  which is the measures created only for tooltips.
  For example : Suppose Sales filter is selected from the slicer, its only supposed to be ""sales by partner" however  Sales, S% and NR % by Partner is popping up!

The slicer is based on this parameter: 
Parameter = {
("Net revenue", NAMEOF('User'[Net revenue]), 0),
("Sales", NAMEOF('User'[Sales]), 1)
}
Measure used: 
S% = DIVIDE([Sales], [Total Sales])
NR% = DIVIDE([Net Revenue], CALCULATE(SUM([Total Net Revenue]), ALL('Data')))
This is the another measure i created for the title: 
Dynamic Title =
SWITCH(
SELECTEDVALUE(Parameter[Parameter], "Default"),
"Net Revenue", "Net Revenue by Partner",
"Sales", "Sales by Partner",
"Default Title"
)
PS: When i use this measure Dynamic Title in the card visual -> title -> Fx , then the whole card is going black!
Despite adjusting the tooltip settings, the S% and NR% (these letters) are still appearing in the card titles. I have tried isolating these values and refining the configuration without success.

Can anyone provide insights into why these measures are affecting the card titles and suggest how to correct this? Any advice on refining the DAX formula or adjusting the tooltip setup would be highly appreciated.

Thank you for your assistance and insights

Please check the screenshot, check the last header, thats the sample of the card, where i am facing the issue because there i have added the tooltip..

[Poojara_D12]

Hi @Anonymous 

The issue arises because your card visuals might be unintentionally picking up multiple measures, possibly due to conflicting configurations or improperly set tooltips.

Here’s how you can fix it:

1. Verify Tooltip Settings:
- Go to each card visual.
- In the Visualizations pane, open the Tooltips section and ensure only the relevant measure(s) are added for the tooltip. Remove any unnecessary ones like S% or NR%.

2. Fix Dynamic Title in Card:
- Ensure your Dynamic Title measure is correct and isn’t inadvertently referencing S% or NR%. Your current measure looks fine:

Dynamic Title =
SWITCH(
SELECTEDVALUE(Parameter[Parameter], "Default"),
"Net Revenue", "Net Revenue by Partner",
"Sales", "Sales by Partner",
"Default Title"
)

3. Apply the Title Measure Properly:
- In the Card visual, go to the **Title** section under the Format pane.
- Click on the fx button next to the Title.
- Set the Field value to the `Dynamic Title` measure and Summarization to Don't summarize.

4. Clear Other Measure Dependencies:
- Make sure S% and NR% are not referenced or added anywhere in the visual setup unless explicitly needed.

5. Card Going Black Issue:
- If the card turns black when applying the dynamic title, ensure:
- The `Dynamic Title` measure is not returning blank or an error.
- The Parameter slicer is properly set up and has a valid selection.

These steps should isolate the measures and prevent S% and NR% from interfering with your titles.

Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Poojara
Data Analyst | MSBI Developer | Power BI Consultant
Please Subscribe my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS 

[Anonymous]

Hey Thanks for the reply but let me give a brief about the tooltips, The tooltips was a requirement from the users so i had to implement the tooltip in the card! so I cant remove it from the card tooltip 😕
Also One more thing, if i add the dynamic title measure to the Fx, the summarize option disappears and then when i hit the apply, the card goes black!

[ValtteriN]

Hi,

Field parametes can cause this behaviour. Instead of the parameter filed you can create a simple slection table. So instaed of this:

Dynamic Title =

var _sel = SELECTEDVALUE(Parameter[Parameter]) RETURN

SWITCH(_sel,

"Measure 6", "Net Revenue by Partner",

"Measure 7", "Sales by Partner"

)

Try this kind of structure:

Dynamic Title =

var _sel = SELECTEDVALUE('Table (44)'[Names]) RETURN

SWITCH(_sel,

"Measure 6", "Net Revenue by Partner",

"Measure 7", "Sales by Partner"

)

Example data:
parameter:

Table 44:

I have added a tooltip page to recreate your situation. In addtion the new table and parameter have an active relationship:

Now when a value is selected in the dimension table coming from table 44 the title and contents change:
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

[Anonymous]

Hey thanks for the reply, but I have so many cards in the dashboard. so will it be applicable and do i have to remove the tooltips as well?