Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
I have a slicer that has 3 metrics, average, total and volume and this filters a table that has a measure which using a SWITCH function will either show average values, total values or volumes.
The AVG and Total are displayed in currency and the volume is in general number which I achieve by adding in the FORMAT function to the measure.
The issue I have is that when I use the FORMAT function in my measure it does not allow me to use conditional formatting which I want so I an add in data bars. If I remove the FORMAt function then the data bars work but then I either have to have everything in currency or in general number!
Any ideas?
Thanks,
Ben
Solved! Go to Solution.
@Ben81 , Format means text, and that will not allow you to this measure a number.
You can use calculation groups, there you can have different format for measures
calculation groups
https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/
Hi @Ben81 ,
The FORMAT function converts a value to text according to the specified format.
In the measure tools directly select a currency format or a general format.
If you use the FORMAT function, you'll get a text format.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Ben81 , Format means text, and that will not allow you to this measure a number.
You can use calculation groups, there you can have different format for measures
calculation groups
https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
27 | |
13 | |
11 | |
9 | |
6 |