DAX expression working for table but not for bar bar chart

[Ferha_Jafri]

Hello Experts,

I am facing an issue in power bi as I have created an inline table as 

View = {"No. of Claims","Total Premium","Total Incurred"}

on the basis of above I wrote an expression as 

Prem_Cla_Inc toggle =

 var selected_toggle = SELECTEDVALUE(View[Value])

 var var_value = SWITCH(TRUE(),

selected_toggle = "Total Premium",FORMAT([Sum_Premium],"$#,##0.00"),

selected_toggle = "Total Incurred",FORMAT([Sum_Incured],"$#,##0.00"),

selected_toggle = "No. of Claims",FORMAT([# Claims],"#,##0"),0

)

 RETURN var_value

the issue as when I am creating a table woth dimention from the main table the data gets populated as

although the chart is not working as below

Not able to understand the issue.

[tharunkumarRTK · Accepted solution]

@Ferha_Jafri 

If you use FORMAT function then your measure output would be a text value but not a numeric value. For your usecase you need to use dynamic format strings. 

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-dynamic-format-strings

Your measure expression can be :

Prem_Cla_Inc toggle =
 var selected_toggle = SELECTEDVALUE(View[Value])
 var var_value = 
SWITCH(
      TRUE(),
      selected_toggle = "Total  Premium", CALCULATE([Sum_Premium],ALLEXCEPT(Final_Table,Final_Table[Loss_Band])),
      selected_toggle = "Total Incurred", [Sum_Incured],
      selected_toggle = "No. of Claims", [# Claims],
      0
            )
 RETURN var_value

Dynamic format string can be :

var selected_toggle = SELECTEDVALUE(View[Value])
var var_value = SWITCH(TRUE(),
selected_toggle = "Total Premium","$#,##0.00" ,
selected_toggle = "Total Incurred", "$#,##0.00" ,
selected_toggle = "No. of Claims", "#,##0" 
,0
)
 RETURN var_value

Need a Power BI Consultation? Hire me on Upwork

Connect on LinkedIn

Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!