How to create a visual with support several different tooltips
Multiple tooltips in Power BI are a useful feature that allow users to display additional information when hovering over a visual object. Using multiple tooltips on the same visual object can provide even more context and insights, by allowing users to access different layers of information with ease. This can be particularly helpful when dealing with complex datasets or when trying to convey multiple messages through a single visual. In this way, multiple tooltips can enhance the user experience and improve the overall effectiveness of a Power BI report.
- Configure your visual
- Create a new page and configure it as below:
- Go to Format page -> Canvas settings -> Type. Change the Type for Tooltip
- Go to Format page -> Page information. Set the checkbox Allow use as tooltip to on
- Go back to your visual's setup. Go to Format visual -> General -> Tooltips set to on
- Change Page option to your tooltip page name
- Add a new measure to detect the selected level of detalization:
WhatIsSelected = SWITCH(TRUE(); ISFILTERED('table'[column1]); 1; ISFILTERED('table'[column2]); 2; ... ; 10) - Notice: the measure is fields order-sensitive
- Add visuals you need into tooltip page and configure them
- For each visual at the page, except first one, go to Format visual -> General -> Effects -> Background and set Transparency value to 100%
11. Add a new measure: B = BLANK()
12. Add a new measure for config caption of our visual like: Caption = IF([WhatIsSelected]=value; "your text"). "Value" is a one of numbers from WhatIsSelected measure
13. Go to Format visual -> General -> Title -> Title -> Text and set up Conditional formatting option as our Caption measure
14. Add a new intermediate measure, like: Name = IF([WhatIsSelected]=3, [a measure name you need to substitute here])
15. Repeat for each measure you want to use in your chart bar and replace your current measures with a new one.
15.1 Following the guide, we can add pictures by URLs from a table. To do it we should add them as a table, then select the table column in a table, switch to Column tools tab at the ribbon and change Data category to Image URL. As we didn't want to show all the images at the same time, download a custom visual named Image by CloudScope and convert our table to a new custom visual.
15.2 This case measure can be like: Photo = IF([WhatIsSelected] = 2, SELECTEDVALUE('table name'[photo URLs column]))
15.3 Add our new measure instead current for CloudScope visual.
16. If you use some visual without transparency value, it cannot be hidden, so we add additional visual Treemap and put in here new measure blank = IF([WhatIsSelected] <> 1, 1) as a value. Disable all components for the Treemap and set the same background color with your page color.
Primary guide source here
Комментарии
Отправить комментарий