Forum Discussion
Dynamic column changing
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
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
5 Replies
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,
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)
You want the same diagram to be able to switch between SQM and SQFT depending on what you filter on in your slicer?
