Limited Tooltip info for Stacked Column Chart

[mariuschrc]

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.

[Ritaf1983 · Accepted solution]

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")+0

Hr 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 attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[Ritaf1983]

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/35839...

if 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/1447523

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[mariuschrc]

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.

[mariuschrc]

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

[Ritaf1983 · Accepted solution]

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")+0

Hr 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 attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[mariuschrc]

Sorry for my late reply and thank you for the tips. It worked! Can you please tell me how do I get rid of "0"s like not showing the departments that have 0 presence on that specific day? And is there any chance I can add the date in that empty space on the top of the tooltip/matrix?

PS. I used this but it still shows me the department name; how I can not show it at all when value's 0?

Marketing = VAR MarketingCount = CALCULATE(DISTINCTCOUNT('Table'[Present]),'Table'[Department]="Marketing")

RETURN IF(MarketingCount = 0, BLANK(), MarketingCount)"

[Ritaf1983 · Accepted solution]

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