Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hello Community,
I am trying to achieve something similar to this post https://medium.com/@enridge/different-ways-to-use-dynamic-measures-in-power-bi-448e226667c1
where I have both percentage formatted measures and number formatted in the same switch calculation. I cannot seem to find the Dynamic option in the format settings like the option in Power BI Desktop:
What I tried doing is forcing the format in the expression itself since I cannot find the dynamic option in Visual Studio, but when placing the measure in a bar chart it doesnt show any data when selecting "% Of Budget" in the slicer. It seems like the visual has an issue handling two different formats.
Dynamic Measure =
SWITCH (
VALUES ( 'Measures List'[Measure Name] ),
"Sales", [Sales],
"Budget", [Budget],
"% Of Budget", FORMAT([% Of Budget],"0.00%)"
)
Best regards,
Oscarca
Thank you for your answer ! The field parameter doesn't serm to be supported in the visual studio tabular designer. It doesn't recognize the "NAMEOF" function that is used in the field parameter syntax.
Field parameters are a good option. Each measure's format is used, and you avoid using the FORMAT function that converts values to text.
https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters
Proud to be a Super User!
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
90 | |
84 | |
70 | |
49 |
User | Count |
---|---|
143 | |
121 | |
112 | |
58 | |
57 |