Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Ferha_Jafri
Frequent Visitor

Tooltip not showng dynamic values in a Bar Chart

Hello Experst, 

 

I am using DAX ecpression as 

Prem_Cla_Inc toggle =
 var selected_toggle = SELECTEDVALUE(View[Value])
 var var_value = SWITCH(TRUE(),
selected_toggle = "Total Premium",[Sum_Premium],
selected_toggle = "Total Incurred",[Sum_Incured],
selected_toggle = "No. of Claims",[# Claims],0
)
 RETURN var_value
 
in the tooltip , on a BAR chart it is showing Prem_Cla_Inc toggle = Value as
Ferha_Jafri_0-1726375318137.png

Although I want if Premium is slected then Premium = 65535 should return.

 

Thanks in advance

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi,@Ferha_Jafri 

Regarding the issue you raised, my solution is as follows:

1.Firstly, you need to create parameter values:

vlinyulumsft_0-1726470264009.png

2.Secondly, modify the parameter values and use them as slicers:

vlinyulumsft_1-1726470264010.png

vlinyulumsft_2-1726470289833.png

3.Finally, adjust the visual objects:

vlinyulumsft_3-1726470316162.png

4.Here is the final result, which I hope meets your requirements:

vlinyulumsft_4-1726470316163.png

vlinyulumsft_6-1726470346535.png

Please find the attached pbix relevant to the case.

 

Best Regards,

Leroy Lu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

View solution in original post

1 REPLY 1
Anonymous
Not applicable

Hi,@Ferha_Jafri 

Regarding the issue you raised, my solution is as follows:

1.Firstly, you need to create parameter values:

vlinyulumsft_0-1726470264009.png

2.Secondly, modify the parameter values and use them as slicers:

vlinyulumsft_1-1726470264010.png

vlinyulumsft_2-1726470289833.png

3.Finally, adjust the visual objects:

vlinyulumsft_3-1726470316162.png

4.Here is the final result, which I hope meets your requirements:

vlinyulumsft_4-1726470316163.png

vlinyulumsft_6-1726470346535.png

Please find the attached pbix relevant to the case.

 

Best Regards,

Leroy Lu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.