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?
