Forum Discussion
How to create comparison dashboards between two categories?
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.
| 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?