Forum Discussion
Splitting a Custom Column Chart Bar Into Units
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.
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
8 Replies
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/1447523
