Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Good afternoon to everyone reading this,
It looks like a simple problem, but I haven't figured this out.
In my report, I have a dashboard which can be filtered by year, month and subcompany. Then I have some graphs, which I created a specfic custom tooltip for each. In my custom tooltip, I have another graph and a text under it, explaining it. However, if I change the subcompany, the values are different, and I need a different text to explain and interpret the graphic, the tooltip graphic is working fine, but the text won't change. I will probably have to create multiple tooltips for each graph, with different texts in each one of them, but I'm not sure if its the best way, nor how to make it, because a graph can only have 1 tooltip.
Anyone has ideas on how to make this work?
Solved! Go to Solution.
Hi @Anonymous ,
I created a simple sample. You could have a try and check if it is what you want.
Measure =
VAR vSelectedValue =
HASONEFILTER ( 'Table'[Country] )
RETURN
SWITCH (
vSelectedValue,
MAX ( 'Table'[Country] ) = "Canada", "A",
MAX ( 'Table'[Country] ) = "Germany", "B",
MAX ( 'Table'[Country] ) = "France", "C",
MAX ( 'Table'[Country] ) = "Mexico", "D"
)
For more details, please see the attachment. If it is not what you want, please share a few screenshots or more details about it. We will understand clearly.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
I created a simple sample. You could have a try and check if it is what you want.
Measure =
VAR vSelectedValue =
HASONEFILTER ( 'Table'[Country] )
RETURN
SWITCH (
vSelectedValue,
MAX ( 'Table'[Country] ) = "Canada", "A",
MAX ( 'Table'[Country] ) = "Germany", "B",
MAX ( 'Table'[Country] ) = "France", "C",
MAX ( 'Table'[Country] ) = "Mexico", "D"
)
For more details, please see the attachment. If it is not what you want, please share a few screenshots or more details about it. We will understand clearly.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Greg_Deckler I'm not familiar with that funcion, how would it look like?
Anyway, thanks @v-xuding-msft for the solution! Works just fine 😃
Hi @Anonymous ,
Glad it works for you. 😊
For the function of ISINSCOPE that Greg suggests, I add some blogs that you could reference.
https://info.enterprisedna.co/dax-function-guide/isinscope/
Use IsInScope to get the right hierarchy level in DAX
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ISINSCOPE is kind of the more modern version of HASONEVALUE.
User | Count |
---|---|
77 | |
74 | |
63 | |
61 | |
45 |
User | Count |
---|---|
108 | |
102 | |
93 | |
83 | |
64 |