Dynamic column changing

[Krcmajster]

I am not sure this is possible but better to ask.

So I have a column with clasiffication by size SQM:

Example:

SQM Class

<1000

1000-5000

5000-10000

>10000

Next to it I have a similar column with SQFT classification.

Now I have a graph and a filter with SQM Classes and I have measure drop-down where defult is SQM. Is there a possibility that by selecting SQFT from the dropdown, classification column changes and with it filter options and graph brakedown. Graph whont change, only the brakedown

[v-cherch-msft]

Hi @Krcmajster 

I cannot fully understand your expected output.Could you show us an example about your expected output with sample data?As far as i know,calculated column could not be dynamic changed by slicer but measure could.Please share more details for us to help with you.

Regards,

[Krcmajster]

@v-cherch-msft  see attached photos:

Size in SQFTSize in SQM

I want the categories (classes) to change when I select different measure from the slicer (SQM, SQFT)

[tex628]

You want the same diagram to be able to switch between SQM and SQFT depending on what you filter on in your slicer? 

[Krcmajster]

@tex628  Exactly

[tex628 · Accepted solution]

To do it you will need to change the datamodel. Instead of having SQM and SQFT in two seperate columns you would need to have the values in the same one:

Size	Class
< 1000	SQM
> 5000	SQM
< 10000	SQFT
> 20000	SQM
< 1000	SQFT
> 5000	SQM
< 10000	SQFT
> 20000	SQFT

With this you can create a slicer on the class column which should give you the result ur aiming for.

Br,
Johannes