Forum Discussion
How to create master conversion button or slicer per page for sq.m to sq.ft
Hello everyone
Relatively new to BI and was looking for some help.
Is there a way to create a slicer or a button or anything else that can switch values on the fly on multiple visualisations between sq.m and sq.ft. Bookmarks is and obvious solution but i m looking for a different approach as it means duplicating way too many visualisations.
Any help or input would be greatly appreciated.
Hi alkinio,
I believe that what you need is to create a measure or several that respond to a slicer and give you the expected outcome in sq.m or sq.f
Without knowledge of your data model you need to create something like this:
Created a table only with values that are going to be converted let's assume this is only in units
Values_To_convert
Cat Value
A 100 B 60 C 30 D 20 E 80 Conversion_Table
Type Conversionfactor
Sq.m 2 Sq.f 3 Conversion factor only for example purposes.
Then create a measure that looks somehting like this:
Convert = SWITCH ( MAX ( Conversion_Table[Type] ); "Sq.m"; SUM ( Values_To_convert[Value] ) * MAX ( Conversion_Table[Conversionfactor] ); "Sq.f"; SUM ( Values_To_convert[Value] ) * MAX ( Conversion_Table[Conversionfactor] ) )Then just add this measure to your charts and conversion will take place:
Again not knowing your model I can't give your further help but hopefully this will guide in the right direction.
Attach PBIX file.
Regards,
MFelix
2 Replies
- MFelix
Super User
Hi alkinio,
I believe that what you need is to create a measure or several that respond to a slicer and give you the expected outcome in sq.m or sq.f
Without knowledge of your data model you need to create something like this:
Created a table only with values that are going to be converted let's assume this is only in units
Values_To_convert
Cat Value
A 100 B 60 C 30 D 20 E 80 Conversion_Table
Type Conversionfactor
Sq.m 2 Sq.f 3 Conversion factor only for example purposes.
Then create a measure that looks somehting like this:
Convert = SWITCH ( MAX ( Conversion_Table[Type] ); "Sq.m"; SUM ( Values_To_convert[Value] ) * MAX ( Conversion_Table[Conversionfactor] ); "Sq.f"; SUM ( Values_To_convert[Value] ) * MAX ( Conversion_Table[Conversionfactor] ) )Then just add this measure to your charts and conversion will take place:
Again not knowing your model I can't give your further help but hopefully this will guide in the right direction.
Attach PBIX file.
Regards,
MFelix
Thank you so much for the help.
Its really useful and close to what i was looking for.
Regards
