Stacked column chart with dynamic legend

Justas4478 

2 solutions for such a visual  
solution 1 ; ( easy approach ) 
use the custom visual : 

if the number of values in the legend is fixed ,  then you can create a measure per each group . 

solution 2 : ( more complex  dax approach ) 

Bas on youtube did create a visual using native power bi  visual and dax,  to create a line chart with table below it. 

i honestly cant remember the name of the video,  but it was on the channel :  how to powerbi ( by bas )

for me, i would go with the first solution. easier .

hope this helps . 

Hi Justas4478 

 I haven't seen a chart like that.

What I would recommend is using tooltips to display the information when hovering over the bars.

For even more detail, create a tooltip page that will show visual information.

Hi Justas4478 ,

You can easily create a stacked column chart with a dynamic legend in Power BI by making a few adjustments to your data. Here’s how you can do it:

1. Import your data into Power BI (Home → Get Data → Excel/CSV).
2. Open Transform Data (Power Query).
3. Select your difference columns (such as Diff1, Diff2, Diff3).
4. Right-click and select Unpivot Columns. This will generate two new columns: one for the difference type (e.g., Diff1, Diff2, Diff3) and one for the values.
5. Rename these columns (for example, “Difference Type” and “Amount”), then choose Close & Apply.
6. Add a Stacked Column Chart visual.
7. Assign StorageType to the Axis, Difference Type to the Legend, and Amount to the Values.

With this setup, your legend will dynamically update when filters are applied, just like in Excel. For a table below the chart, simply add a Matrix visual using StorageType as rows, Difference Type as columns, and Amount as values. This approach will deliver the results you need.

I’ve attached the .pbix file and screenshots for your reference.

Thank you,

Tejaswi.