Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi, need help with the following:
The PBI report has a slicer of 2 currencies, US$ and Euro. Have a matrix visual with prices.
What is needed is to display the prices formatted according to the currency selected.
Please advise how can I do this.
Thanks
Solved! Go to Solution.
@Chapin4u wrote:
Hi, need help with the following:
The PBI report has a slicer of 2 currencies, US$ and Euro. Have a matrix visual with prices.
What is needed is to display the prices formatted according to the currency selected.
Please advise how can I do this.
Thanks
You could try to create a measure if you have a table like
price Measure = SWITCH ( ISFILTERED ( price[currency] ) && HASONEVALUE ( price[currency] ), LASTNONBLANK ( price[currency], "" ) = "Euro", FORMAT ( MAX ( price[price] ), "€##.00" ), LASTNONBLANK ( price[currency], "" ) = "US$", FORMAT ( MAX ( price[price] ), "$##.00" ), FORMAT ( MAX ( price[price] ), "$##.00" ) //if the slicer doesn't pick up any currency, use US$ by default )
@Chapin4u wrote:
Hi, need help with the following:
The PBI report has a slicer of 2 currencies, US$ and Euro. Have a matrix visual with prices.
What is needed is to display the prices formatted according to the currency selected.
Please advise how can I do this.
Thanks
You could try to create a measure if you have a table like
price Measure = SWITCH ( ISFILTERED ( price[currency] ) && HASONEVALUE ( price[currency] ), LASTNONBLANK ( price[currency], "" ) = "Euro", FORMAT ( MAX ( price[price] ), "€##.00" ), LASTNONBLANK ( price[currency], "" ) = "US$", FORMAT ( MAX ( price[price] ), "$##.00" ), FORMAT ( MAX ( price[price] ), "$##.00" ) //if the slicer doesn't pick up any currency, use US$ by default )
Thanks for taking your time to show me the solution and the screen shots.
Hi @Chapin4u
You can use the FORMAT function to create formatting to suit
eg,.
Currency US = FORMAT(100,"$##.00")
or
Currency EU = FORMAT(100,"€##.00")
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
122 | |
101 | |
71 | |
61 |