Forum Discussion
Splitting a Custom Column Chart Bar Into Units
Hi Chemkhi
The bar tooltip has the same filter context as the bar itself.
If it is only months you will see the month's qty.
If you want to split it by another filter context for example business units, you can create a customized tooltip.
For more information please refer to the linked tutorial:https://www.youtube.com/watch?v=cGpBUJpFWrM
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi Chemkhi
As I mentioned in my first response you need to create a desired tooltip 🙂You can format and design it better than me, I just put the data of the basic table to let you see what I am talking about.
From this point, you can use a tutorial that I linked in my first response.
Pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
You can make this "window" larger,
just customize the size from here:Remember that you don't have to see all rows in the visual when you design it because on the bars hover it is always filtered by the bar's context.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi Chemkhi
The bar tooltip has the same filter context as the bar itself.
If it is only months you will see the month's qty.
If you want to split it by another filter context for example business units, you can create a customized tooltip.
For more information please refer to the linked tutorial:
https://www.youtube.com/watch?v=cGpBUJpFWrM
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hello Ritaf1983
thank you for your reply, but what I'm trying to do is: you see March for example in the picture has 3 accidents, 2 occurs on the same day for example, when I make a different visual by day and in the tooltip bar I put the additional information that I want to see when I hover, it shows me only 1 accident informations not two, because the clustered column chart bar isn't divided in two seperate units, that's what I'm trying to do and I didn't find away to do it.
Hi Chemkhi
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/1447523ID Age Sex Sector Date of The Accident 4201 30 F PRODUCTION 16.03.23 4202 19 H Logistique 16.03.23 4203 45 H Maintenence 18.03.23 4204 29 H Logistique 07.04.23 4205 31 H Maintenence 18.06.23 4206 21 F PRODUCTION 29.08.23 for example on march the 16th there are two accident by the tooltip shows the information just about one, my question is how can I show the information about the two accidents just with hovering on the bar?
Thank you again Ritaf1983
