Switch grouped dimension via filter

Schmidtmayer — Thu, 09 Sep 2021 13:36:15 GMT

Hello there, photos of sample data below.

The dataset contains a facttable including 2 columns to group (value 1 and value 2) by certain property coloumns (property1 and property2).

I do know it is possible to switch between displayed measures using DAX, as shown in the sample data. I am interested in the following: Is it possible to switch VIA FILTERS between the grouped properties?
Means: I want add another filter with options property1 and property2. Choosing property1 reveals page 1 of the report, values grouped by property1. Choosing property2 will show the values grouped by property2. Is this possible?

A solution via filters prefered, as the current solution is to have, just like the report, one page for every property to be grouped by and switching via tab navigation.

In genereal, the number of values may increase, as well as the number of properties to be grouped by. Also, every property may have a different number of options, some being binary, some being multivalued.

Thanks in advance
DataSet:
FactTest conntected to DimProperty1 via DimPropert1.ID and FactTest.property1
FactTest conntected to DimProperty2 via DimPropert2.ID and FactTest.property2
DimSwitch used for switching measures via filters

grouped by property1:

grouped by property2:

Re: Switch grouped dimension via filter

lbendlin — Sat, 11 Sep 2021 16:22:29 GMT

Enable "Personalize Visual" and teach your users how to do it (and how to swap dimensions). If you don't like that, use bookmarks to show/hide individual visuals.

topic Re: Switch grouped dimension via filter in DAX Commands and Tips

Switch grouped dimension via filter

Re: Switch grouped dimension via filter