Splitting a Custom Column Chart Bar Into Units

[Chemkhi]

I'm using tooltips informations but not a lot in the picture below I'm trying to split the custom column chart bar into units so when I ever hover on it it shows the exact informations seprately of that particular unit not of the whole bar.

 so if I click on the top of March bar it shows me total accidents is 1 with the additional tooltips informations that I can put.

Thnx.

[Ritaf1983 · Accepted solution]

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

[Ritaf1983 · Accepted solution]

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

[Ritaf1983 · Accepted solution]

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

[Chemkhi]

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.

[Ritaf1983]

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

[Chemkhi]

ID	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 

[Ritaf1983 · Accepted solution]

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

[Chemkhi]

I have a lot more data to attach to that so I don't know if it's efficient but I guess this is good for now.
thanks again @Ritaf1983 

[Ritaf1983]

Glad to help 🙂

Please consider Accepting it as the solution to help the other members find it more quickly

[Ritaf1983 · Accepted solution]

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