Forum Discussion
Static Barchart
Hello,
I am trying to create a barchart that shows the top 20 products by volume for a given time period, nationwide, with a slicer for different companies. The goal is to for the bars to show the % share that the selected company has in each product, but I want the bar chart to a) continue to show the top 20 products nationwide, regardless of whether these are the top 20 products for the selected company and b) remain static in order of #1 to #20 by volume, again nationwide, regardless of whether the company's share reflects the same order. Very rough sketch of what I have in mind below. Does anyone know how to do this? I considered a "sort by" column that labels the products as 1-20 in a hidden column and then the chart theoretically wouldn't adhere to size order by company, but I'd ideally like the top 20 products to be actually reflective of the top 20 by volume for that time period and therefore flexible to changing if they switch order over time, rather than hardcoded. Thanks for any help!!
2 Replies
I think you can get that easily by disabling visual interactions between the company slicer(s) and your nation-wide visual. Read this for more info: https://learn.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions?tabs=powerbi-desktop
but then the chart wouldn't represent the share of each product that the selected company holds, right?
my ideal chart would show the top 20 products by sales volume in descending order when the company slicer is blank/set to all. then when company A is chosen, I want to see the same order of products from left to right, but the bars would then show company A's share of sales of each product compared to all companies. the reason I need the products to remain in static order is to make it easier to compare/see differences between company performance against products. product A might be a great product for company A, but company B maybe doesn't have any share at all in product A. I still want product A to remain in the product A spot, but it would show 0 share for company B (as opposed to disappear off the chart or move to the last spot to the right). that way when I switch to company C, I see that for the same product A, which is the biggest product in the country, they perform better in share than company B, but maybe not as good as company A, without that product bouncing all around the chart.
