Forum Discussion
gfdytr4
Helper I
Helper IHierarchy bar chart based on measures
Hi, I have a bar chart with the months as my X-axis and 3 measures in Y-axis. Meaure 1: Total cost consultants Meaure 2: Total cost consultants from Company A Meaure 3: Total cost consultants f...
Hi gfdytr4 ,
Thank you for reaching out to the Microsoft fabric community forum. Also thank you danextian
As mentioned by rohit1991 , Power BI doesn’t natively support measure-level drill-down in bar/column charts.
The most reliable approach is using a Matrix visual, where you can place measure labels (with levels) on rows and time on columns, allowing drill-up/down natively.
I hope this is clear. If you have any further questions, please feel free to reach out.
Thank you.
danextian
Super User
Super UserIf you mean to show a total bar then total for each individual company like below, you will need to use a disconnected table containing a column of company names and a row for the word total.
Please see the attached pbix.