Forum Discussion
Advanced histogram parametring by cluster of data
Hi people!
I have once again an issue, concerning histogram parametring.
Below are the samples:
- my data is as seen in the table : division by country/region/zone/dealer
- my histogram should show the ratio Sales/offers, but 4 times:
- sales(country)/offer(country)
- sales(region)/offer(region)
- etc.
--> Constraint: their are several slicers allowing the user to choose country/region/zone/dealer but I need to be able to show, for each level of filtering,
- the complete data for the country
- complete country + the region data according to the one selected
- complete country + the region data according to the one selected + the zone selected
- complete country + the region data according to the one selected + the zone selected + dealer selected.
Here are samples :
| Country | Region | Zone | Dealer | Product | Offers | Sales | %Country | %Region | %Dealer | %Zone |
| France | 1 | 1 | 1001 | Pdt 1 | 15 | 5 | 70% | 44% | 33% | 33% |
| France | 1 | 2 | 1002 | Pdt 2 | 45 | 21 | 70% | 44% | 47% | 47% |
| France | 1 | 3 | 1003 | Pdt 3 | 2 | 1 | 70% | 44% | 50% | 50% |
| France | 2 | 4 | 1004 | Pdt 1 | 6 | 3 | 70% | 78% | 50% | 50% |
| France | 2 | 5 | 1005 | Pdt 2 | 67 | 54 | 70% | 78% | 81% | 81% |
| France | 3 | 6 | 1006 | Pdt 3 | 54 | 35 | 70% | 80% | 65% | 65% |
| France | 3 | 7 | 1007 | Pdt 1 | 24 | 24 | 70% | 80% | 100% | 100% |
| France | 3 | 8 | 1008 | Pdt 2 | 22 | 21 | 70% | 80% | 95% | 95% |
| France | 4 | 9 | 1009 | Pdt 3 | 1 | 1 | 70% | 100% | 100% | 100% |
Screenshot:
One Region selected
To all, thanks!
Noob
Hi Noob78，
Click your field(for example:%Country) in Fields Panel, then under Modeling ribbon,click the percentage format, you will get your desired result.
Thanks,
Lydia Zhang
5 Replies
up?
Hi Noob78,
Based on your description and screenshots, it seems that you want to create a column chart using sample data in Power BI Desktop and want to filter it with different levels of slicers, right?
If that is the case, you can create a Clustered column chart using fields as shown in the following screenshot, then create 4 slicers using country/region/zone/dealer field. You will be able to filter the chart using slicers at different levels.For more details, you can review this attached PBIX file.
Thanks,
Lydia Zhang
