Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
How to write formula for custom tooltip, which will depend on each visuals hover
i need get tooltips values from different tables and columns, depending on which visual is hovered
something like that
ToolTip =
SWITCH(
TRUE(),
isfiltered('DBA2'[OB2]),values('DBA2'[OB2]), //1 visual
isfiltered('DBAS'[OBJ]),values('DBAS'[OBJ]), //2 visual
isfiltered('DBA3'[OB3]),values('DBA3'[OB3]), //3 visual
[OB4] // others
)
but that formula not work properly
Perhaps, you need the technique like this https://docs.microsoft.com/en-us/power-bi/desktop-tooltips
Yes, i using that, but it require to create new tooltip to each visual, so on report page i have 12 visuals and must create 12 pages for tooltips, which makes it difficult to navigate through the pages
Hi @Analitika ,
Unfortunately, the tooltip will show values automatically. It can't be changed based on slicers. For your situation, I'm afraid there is not a good workaround to solve it. You may need to create one by one for different visuals.
If you really need the feature, you could submit request in Power BI Ideas.
I do not completely understand your data model and requirement, so if you provide more detailed information (maybe screenshots), we will able to help you
Data model is not important, i need to have only one custom tooltip page, and use this tooltip in all visuals, but each visual can refer to different columns an mesuares, so there i need formula, to describe, in wich visual i want to see which column info, that is it.
Or how to catch hover event on each visual, when tooltip appear?
this tooltip will have the same format in each visual?
Yes, same format
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |