Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I am using a a SelectMeasure so that the user can filter by the indicator he wants (facturation or sales). But by using switch true I lose the format of [sales] (which should appear as an entire number). Both facturation and sales appear with "€" at the end. Here is my formula :
Solved! Go to Solution.
Hi @DM_BI ,
As I mentioned above, using FORMAT function will force the returned data type by measure to be converted to Text. It is not supported to add Text value into "Value" section of a chart.
In your scenario, to achieve such a conditional format in Chart visual, it is not available now.
Regards,
Yuliana Gu
Hi @DM_BI,
Please modify the measure formula as:
Indicateur = IF ( ISCROSSFILTERED ( SelectMeasure[Measure] ), SWITCH ( TRUE (), VALUES ( SelectMeasure[Measure] ) = "Facturation", FORMAT ( [Sum_fact], "Currency" ), VALUES ( SelectMeasure[Measure] ) = "Number of sales", FORMAT ( [Sum_number of sales], "General Number" ), BLANK () ), BLANK () )
However, the data type of returned result by this measure will be converted to Text.
Best regards,
Yuliana Gu
Hi Yuliana,
Thank you, it works in the sample! My card show now the currency or general number. But it's weird that in my graph now I don't see any value... And in the sample it is impossible to drop the measure "Indicateur" to the value field of the chart.
Thank you for your help,
DM
Hi @DM_BI ,
As I mentioned above, using FORMAT function will force the returned data type by measure to be converted to Text. It is not supported to add Text value into "Value" section of a chart.
In your scenario, to achieve such a conditional format in Chart visual, it is not available now.
Regards,
Yuliana Gu
Hello Yuliana,
Ok I got it thank you. Is there any idea to vote it ?
Best regards,
DM
You can see the problem in this pbix file : https://db.tt/tUBU6kkquf
When you select "facturation", the card on the left does not show that it is actually in euros.
Thank you in advance for anyone who can help me fix this...
DM
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |