Forum Discussion
Solved
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...
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
You want the same diagram to be able to switch between SQM and SQFT depending on what you filter on in your slicer?
tex628 Exactly
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