Forum Discussion
Switching Qty and $ Amount Formatting for Measure in Visual
Hello!
What is the best way to switch between a quantity number and currency dollar amount formatting in a measure that shows in both a matrix and visual? I have a Gross/Net/Qty toggle applied to measures - Total Sales for example - and would like to be able to toggle between Gross and Net $# and Qty as #. The custom formatting in dax I have tried has worked for the matrix but not the visual.
Thank you for your help!
Hello inelson ,
you can have three measures for each and formatted as you want it.
the key is that you use field parameters to switch between them and it will achieve as your result now.
''check the concept of field parameters https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters
Hi,
Thanks for the solution Idrissshatila offered, and i want to offer some more information for user to refer to.
hello inelson , you can also consider to use dynamic format in measure, you can refer to the following link about it.
Create dynamic format strings for measures in Power BI Desktop - Power BI | Microsoft Learn
Introducing dynamic format strings for DAX measures - SQLBI
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hello inelson ,
you can have three measures for each and formatted as you want it.
the key is that you use field parameters to switch between them and it will achieve as your result now.
''check the concept of field parameters https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters
Hi,
Thanks for the solution Idrissshatila offered, and i want to offer some more information for user to refer to.
hello inelson , you can also consider to use dynamic format in measure, you can refer to the following link about it.
Create dynamic format strings for measures in Power BI Desktop - Power BI | Microsoft Learn
Introducing dynamic format strings for DAX measures - SQLBI
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.