Forum Discussion
How to create comparison dashboards between two categories?
Hello All,
Im looking for inspiration how to create a good comparison dashboard between two categories inside different dimensions?
Basically idea:
- On the top i want to have field parameter, where im choosing dimension (dimension means one of the column from table), which i will perform comaprison between two categories from chosen dimension.
- Below i want to have two slicers, where i will choose one category vs second category.
- The next step is creating some charts, when i will compare values for particular months, comparing variance, average etc.
Do you have any ideas how to setup this kind of settings?
I started to create, but its not working how i expect. In slicers for value i made separate two tables with values for particular dimensions and i created relationship between field parameter and them.
Please refer to this:
Here's a sample:In the power query, Duplicate the Table then select the Platform and Group columns and click unpivot the columns:
The result:
Duplicate the table(2):
Apply and Close.
Create 2 Slicers with the Table(2)[Attribute] and Table(2)[Attribute]:
Then give them the same name to create Sync slicer on one page:
Hide one of them:
Create 2 Slicers with Table(2)[Value] and Table(3)[Value]:
Finally create a clustered column chart, the result is as follow:
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
6 Replies
Please share sample data (excluding sensitive information) in text format, along with your expected result and any relevant logic. For guidance, refer to
How to provide sample data in the Power BI Forum
If possible, upload a simplified .pbix file using this guide:
Something like this
Number Platform Groups INC0097390 DCE1 Direct INC0097398 Other Other INC0097476 DTE Indirect INC0097478 Other Other INC0097480 DCE2 Direct INC0097485 DTE Indirect INC0097488 DCE2 Omni INC0097500 DCE2 Other INC0097508 DCE2 Indirect INC0097514 Other Other INC0097520 DCE1 Direct INC0097524 DCE2 Indirect INC0097529 Other Other INC0097531 Other Other INC0097537 DCE2 Omni INC0097539 DCE2 Direct INC0097541 DCE1 Direct
Here is a sample of Data. We can do it simple as possible. Field parameter is containing two columns Platforms and groups, on y-axis of chart we can just count of number tickets and i want to have possibility to choose first based on which i want to compare, second what values from column im comparing.Can you show the desired result?
Please refer to this:
Here's a sample:In the power query, Duplicate the Table then select the Platform and Group columns and click unpivot the columns:
The result:
Duplicate the table(2):
Apply and Close.
Create 2 Slicers with the Table(2)[Attribute] and Table(2)[Attribute]:
Then give them the same name to create Sync slicer on one page:
Hide one of them:
Create 2 Slicers with Table(2)[Value] and Table(3)[Value]:
Finally create a clustered column chart, the result is as follow:
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
