cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Stacked bar chart ignore legend filter

Let's say I have a stacked bar chart. Each bar(on the y axis) represents a store. The a-axis is a measure which is a percentage of items which have sold more than a certain amount. There is a slider on the report which allows you to select this amount. the calculation of the x-axis measure is basically distinct count of items filtered where only those who have sold more than whatever amount you've set are included all divided by the total number of items. Now, for the legend, I have set an item category dimension. What I want is for each section of the stacked bar to represent the percentage of items which have sold more than the selected amount, out of the total number of items. But what I get instead is the percentage out of only the items in the category represented by that division of the bar. Is there any way to achieve what I am looking for?

1 REPLY 1
Moderator Eric_Zhang
Moderator

Re: Stacked bar chart ignore legend filter


@Anonymous wrote:

Let's say I have a stacked bar chart. Each bar(on the y axis) represents a store. The a-axis is a measure which is a percentage of items which have sold more than a certain amount. There is a slider on the report which allows you to select this amount. the calculation of the x-axis measure is basically distinct count of items filtered where only those who have sold more than whatever amount you've set are included all divided by the total number of items. Now, for the legend, I have set an item category dimension. What I want is for each section of the stacked bar to represent the percentage of items which have sold more than the selected amount, out of the total number of items. But what I get instead is the percentage out of only the items in the category represented by that division of the bar. Is there any way to achieve what I am looking for?


@Anonymous

You description is a little confusing me, could you post any sample data and expected output? Even better your can upload one pbix file. You can upload the pbix file to Onedrive/GoogleDrive and share the download link. Do remember to mask sensitive data before uploading.

Helpful resources

Announcements
Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 324 members 3,665 guests
Please welcome our newest community members: