Forum Discussion
Stacked Column Chart with Legends and Field Parameters
I had the following scenario:
I created a field parameter with two measures:
Sales Shoes/Boots =
{
("Shoes Sold", NAMEOF('Sales'[Shoes]), 0),
("Boots Sold", NAMEOF('Sales'[Boots]), 1)
}
I used a stacked column chart with Brand on X axis and the field parameter on the Y axis. I created a slicer with the field parameter where either Shoes Sold or Boots Sold or both could be selected. When I select both, it shows me the total on the column chart.
So far, so good.
However, then I added Country as the legend. Now, when I select, Shoes Sold from slicer, it gives me a breakdown of Shoes sold per brand with its column being broken down per region. And when I select both Boots Sold, then it gives me a breakdown of Boots Sold per brand with it's column being broken per region. However, when I select both, it still only shows me for Shoes Sold and not for the total which was previously happening before I added the legend.
Is this a limitation in Power BI when using legends with field parameters where only one measure can be displayed at once or am I missing something?
1 Reply
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
