Forum Discussion
Advocate IIFormat function destroys some of charts!
It's fantastic that in the "Table" or text based Custom Visual like "Card" every thing is ok!!! in the charts I have problem. when I change "Pie Chart" to Table I see my result in the $,Euro and IRR format! I think it's a bug maybe!
Advocate II
Thanks for your reply.
In fact your exmpale worked and I knew that, But I need this one my friend :
Value( Format (Sales[sales_values],"$#,##0;($#,##0)"))
custom format for showing $:
https://msdn.microsoft.com/en-us/library/ee634206.aspx
Thanks a lot
Resident RockstarHey dude , pls look this screenshot i hope it will help u .
Note :
Negative and Zeros are not display in Pie Chart
- MrPowerBIPro
Thanks a lot Baskar
When you create a
calculated column and drag it to pie chart it is ok.
Let me say my exact problem:
1- Currency_Table:
CurrencyType Rate Euro 40,000.00 IRR 1.00 Dollar 35,000 2- This is a measure:
Sales_Amount_With_Currency =
IF(VALUES(Currency_Table[CurrencyType])="Dollar",FORMAT(ROUND(SUM(Sales_Table[Sales Values (Rial)])/[Dollar],0),"$#,##0.00;($ #,##0.00)") ,
IF(VALUES(Currency_Table[CurrencyType])="Euro",FORMAT(ROUND(SUM(Sales_Table[Sales Values (Rial)])/[Euro],0),
"€#,##0.00;(€ #,##0.00)"),FORMAT(ROUND(SUM(Sales_Table[Sales Values (Rial)])/1,0),"IRR #,##0.00;(IRR#,##0.00)"))
)
3- "Dollar","Euro","IRR" is a slicer.
I hope it is clear!
Thanks again for your time my friend
Regards
Mostafa
- MrPowerBIPro
It's fantastic that in the "Table" or text based Custom Visual like "Card" every thing is ok!!! in the charts I have problem. when I change "Pie Chart" to Table I see my result in the $,Euro and IRR format! I think it's a bug maybe!
