Sunday, December 22, 2019

How to add a Custom Tool tip to a Visual in Power BI

How to use Custom Tool tip for a Visual in Power BI
Scenario :
Suppose we have a Tree Map visual in our Dashboard, which showing only the Net Sales by Region.
However, the Customer is interested to know the details like Order_Date, Order_Id, Product Names for when hover on a particular region of the Tree Map as shown below : 

We can achieve this by creating a new ToopTip page or a Custom Page with the Details that Customer needed to show in ToolTip.
Once we created the Custom Page, then we can call that ToolTip page to the Visual>ToolTip
Type>Report page section.

Now we will discuss the above ToolTip creation and implementation process in detail.

Phase-1 :
First Create a new Custom Page and set the Page properties as per your requirement.


Please make sure to Tooltip option On in Page Information.


Define the Size of the Page as per your requirement.


Next design a Table with details of the Sales Orders that we need to show in ToolTip.


Now the Tooltip page is ready to Use. 

Phase-2 :
Go to the Dashboard page and Select the Vislual(eg.Tree Map here)
Next we can select the above ToolTip page "TT_SalesDetail" at the Visual>Format>ToolTip Type>Report page section.


Thats all. Now we can see the Sales Orders details in Tooltip when we hover on a particular section of the Visual.



Note:
We can hide the Tooltip page before Publishing the Dashboard to the Service.

-------------------------------------------------------------------------------------------------------- 
Thanks, TAMATAM ; Business Intelligence & Analytics Professional 
--------------------------------------------------------------------------------------------------------

No comments:

Post a Comment

Hi User, Thank You for visiting My Blog. Please post your genuine Feedback or comments only related to this Blog Posts. Please do not post any Spam comments or Advertising kind of comments which will be Ignored.