How to create comparison dashboards between two categories?

[Jakub_Poweska11]

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.

[Anonymous · Accepted solution]

Hi @Jakub_Poweska11 

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.

[Jakub_Poweska11]

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.

[Ritaf1983]

Can you show the desired result?

[Jakub_Poweska11]

[Ritaf1983]

Hi @Jakub_Poweska11 

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:

 How to upload PBI in Community

[Jakub_Poweska11]

Something like this