Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |