Dynamic Table Columns With Slicer Using Field Parameters

DAX DAX Calculations
1

Hi,

I have a table visual that is controlled by slicer and both are using field parameters. It’s working fine but I would like to modify the slicer. The slicer currently has 9 values:

  • Kiosk Revenue
  • Kiosk Comparative
  • Kiosk Variance
  • TEX Revenue
  • TEX Comparative
  • TEX Variance
  • Online Revenue
  • Online Revenue Comparative
  • Online Revenue Variance

I would like to reduce it by categorizing the values into:

  • Kiosk
  • TEX
  • Online Revenue

So based on the above changes, the operation will be the same i.e.

  • when “Kiosk” is selected, the columns “Kiosk Revenue”, “Kiosk Comparative”, and “Kiosk Variance” will show on the table

  • when “TEX” is selected, the columns “TEX Revenue”, “TEX Comparative”, and “TEX Variance” will show on the table

  • when “Online Revenue” is selected, the columns “Online Revenue”, “Online Revenue Comparative”, and “Online Revenue Variance” will show on the table

  • when no values selected, all columns will show on the table

Is this possible to achieve? Hope that makes sense. Appreciate any help, thanks.

Pbix file for reference
https://drive.google.com/file/d/1EEW1KK33DArAHRH34VqZNjNk6KqJPaFM/view?usp=sharing

2

Hi @melq64 ,

I have problem with opening pbix file that you provide for reference.

you can categorized sliced by parameters - you need to change Param Site Detail Category and add this categories you need.

More you can see at :

Hope it helps.

3

Hi @mspanic, thank you for the feedback.

However, I still don’t understand how to categorize / group the 9 values in slicer into 3 groups since the values in the slicer are all measures. Also, the 3 values that I would like to group are not available in the data model as columns or measures.

I can’t upload pbix here coz it exceeds the size limit even after I removed all pages and left 1 page in the file. Can you please try this link instead. Hope it works for you.

Appreciate your help please. Thanks.

4

Issue fixed. I created a table for the 3 categories and used as a slicer. Then created measure for values of the table visual. Didn’t need to use field parameters.

Thanks for the suggestions and appreciate your help.

1 Like