Forum Discussion
Limited Tooltip info for Stacked Column Chart
Can the "tooltip" include all the departments when hovernig over the data for a single day? Right now it is difficult to see the total number of people from each department, as I can only see 1 department at a time. I don't need to show the totals but the "present" value for all departments for each day.
Hi mariuschrc
Take a look at my answer to the linked discussion :
https://community.fabric.microsoft.com/t5/Desktop/Single-Stack-selection-in-Stackbar-chart/m-p/3583973if it isn't the same issue
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi mariuschrc
As I explained in my response at the discussion that you looked at, the generic tooltip has e context of the graph ( this is a reason that you see just the part that you are hovering)
So, if you need it in another way you can generate the tooltip in the needed format and use the functionality of a customized tooltip.
For this you need to create a measure for every department like :Finance seats = CALCULATE(DISTINCTCOUNT('Table'[Present]),'Table'[Department]="finance")+0Hr seats = CALCULATE(DISTINCTCOUNT('Table'[Present]),'Table'[Department]="HR")+0...then create on another page visuals with these measures + some shapes for the colors :Modify a new page as a tooltip page
From the graph change the tooltip option from default to customized:
Result (if there was more than 1 day every bar were filtered the tooltip according to a specific day)
more information about customized tooltips:
https://www.youtube.com/watch?v=r3sI7pHbdHw
pbix with example is attachedIf this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi mariuschrc
Glad to help please consider Accepting it as the solution to help the other members find it more quickly.According to other questions:
1. I don't think there is an option to filter zeros because there are measures and not table rows.
2. About the date you can create a measure like :Selected date = " Seats distrubution for " & SELECTEDVALUE('Table'[Date/Time])and use it as a title
modified pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
6 Replies
Hi mariuschrc
Take a look at my answer to the linked discussion :
https://community.fabric.microsoft.com/t5/Desktop/Single-Stack-selection-in-Stackbar-chart/m-p/3583973if it isn't the same issue
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi Ritaf,
Thank you for your quick reply. This solution does not match my issue Solved: Single Stack selection in Stackbar chart - Microsoft Fabric Community
I will add the sample data + an image I created to emphasize what I am looking for.
I am using a Line and Stacked Column Chart
Hi mariuschrc
As I explained in my response at the discussion that you looked at, the generic tooltip has e context of the graph ( this is a reason that you see just the part that you are hovering)
So, if you need it in another way you can generate the tooltip in the needed format and use the functionality of a customized tooltip.
For this you need to create a measure for every department like :Finance seats = CALCULATE(DISTINCTCOUNT('Table'[Present]),'Table'[Department]="finance")+0Hr seats = CALCULATE(DISTINCTCOUNT('Table'[Present]),'Table'[Department]="HR")+0...then create on another page visuals with these measures + some shapes for the colors :Modify a new page as a tooltip page
From the graph change the tooltip option from default to customized:
Result (if there was more than 1 day every bar were filtered the tooltip according to a specific day)
more information about customized tooltips:
https://www.youtube.com/watch?v=r3sI7pHbdHw
pbix with example is attachedIf this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Sample data -> https://we.tl/t-8fn9P2E9L2
PS. Please consider the data from the screenshots differ from the one shared via this link but the idea is the same.
