Forum Discussion
Stacked Column chart
Hi guys,
I am a beginner in Power BI, I need your help with somthing on Stacked Column chart.
I want to show some result by quarter (on the X axis), and for Y axis I am using a measure. I have a matrix on the same page, what I want to achieve is that when I select an item on the Matrix (it is a profit and loss statement), it will automatically adjust the chart.
For example, below you can seee that when I select "Material Costs Parts", it automatically updated the Line chart, the results are good, however and the Stack column chart, it is not working, because it shows the total amount of everything (which is meaning less), and ONLY Highlight Material costs parts, is there a way that the Stacked column chart shows only "Material costs Part" or any other thing depending my selection?
thanks.
1 Reply
- lbendlinSuper User
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-p/963216
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