Forum Discussion
Tooltips (beginners question)
Hi Andrew-HLP ,
Thank you for reaching out to Microsoft Fabric Community Forum.
DataNinja777 Thank you for your response.
Andrew-HLP You're on the right track using ISINSCOPE() to detect the current level in the matrix. Since your goal is to show the next level down in a dynamic Tooltip based on what's currently expanded in the matrix, here's an approach that works well in practice:
Instead of trying to dynamically change the field parameter (which Power BI doesn't currently support conditionally), you can use multiple visuals on your Tooltip page,one for each level of detail and control their visibility using DAX.
For example, you could create measures like:
ShowLevel3InTooltip =
IF(
ISINSCOPE('GL Map Accounts'[Level 2]) && NOT ISINSCOPE('GL Map Accounts'[Level 3]),
1,
0
)This measure checks if you're currently viewing Level 2 and hides the visual unless you're hovering at that level.
Then on your Tooltip page:
- Add a visual for each level you want to show (e.g., Level 3, Level 4).
- Use a visual-level filter on each one like ShowLevel3InTooltip = 1 to ensure only the correct level is visible based on the matrix drill level.
This gives users a clean experience where the Tooltip always shows the next level of detail, depending on how far they've expanded in the matrix.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Regards,
B Manikanteswara Reddy
Hello, thanks for the reply. You are right, I am currently using SWITCH and ISINSCOPE() to return the current level / next level (current level + 1). Switching to a table might be neater, but it doesnt solve my problem.
My mapping table ('GL Map Accounts') table looks like this:
NB: I realise I could make this more efficient by holding the mapping for each pair of levels (e.g. Level 1 and Level 2, Level 2 and Level 3, Level 3 to Level 4) in seperate tables but users find a flat structure easier to work with.
I want rows in the Tooltip window to dynamically change to show the next level down when I hover over a cell. Its easy enough to fix the level or even dynamically change it using the parameter and slicer
Code for Parameter (doesn't allow conditional statements within it)
Andrew
Hi Andrew-HLP ,
Thank you for reaching out to Microsoft Fabric Community Forum.
DataNinja777 Thank you for your response.
Andrew-HLP You're on the right track using ISINSCOPE() to detect the current level in the matrix. Since your goal is to show the next level down in a dynamic Tooltip based on what's currently expanded in the matrix, here's an approach that works well in practice:
Instead of trying to dynamically change the field parameter (which Power BI doesn't currently support conditionally), you can use multiple visuals on your Tooltip page,one for each level of detail and control their visibility using DAX.
For example, you could create measures like:
ShowLevel3InTooltip =
IF(
ISINSCOPE('GL Map Accounts'[Level 2]) && NOT ISINSCOPE('GL Map Accounts'[Level 3]),
1,
0
)
This measure checks if you're currently viewing Level 2 and hides the visual unless you're hovering at that level.
Then on your Tooltip page:
- Add a visual for each level you want to show (e.g., Level 3, Level 4).
- Use a visual-level filter on each one like ShowLevel3InTooltip = 1 to ensure only the correct level is visible based on the matrix drill level.
This gives users a clean experience where the Tooltip always shows the next level of detail, depending on how far they've expanded in the matrix.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! |
Regards,
B Manikanteswara Reddy
Hi Andrew-HLP ,
We wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.
Regards,
B Manikanteswara Reddy
Hi Andrew-HLP ,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.
Regards,
B Manikanteswara Reddy
Hi Andrew-HLP ,
May I ask if you have gotten this issue resolved?
If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.
Please don't forget to give a "Kudos " – I’d truly appreciate it!
Regards,
B Manikanteswara Reddy