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:
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.