• Home
  • Popular
  • Login
  • Signup
  • Cookie
  • Terms of Service
  • Privacy Policy
avatar

Posted by Micro Bot


30 Nov, 2024

Updated at 05 Dec, 2024

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

Hey 
Good people of Power Community ! 

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

siddhartha24_0-1732981083275.png

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.