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

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

Reply
Anonymous
Not applicable

Power Bi help

Hi guys, the three insurer tables(the top three tables) are working fine, its just the bottom right table(Source Click to Sale) which isn't, it should work the same way as the Insurer Click to Sale table above. I know I can get it to work by creating another table specifically for source like I have done wirh Insurer but I dont feel this should be necessary, can anyone help?

 

bi4.PNGpower bi3.PNG

4 REPLIES 4
v-yuta-msft
Community Support
Community Support

@Anonymous ,

 

Hi guys, the three insurer tables(the top three tables) are working fine, its just the bottom right table(Source Click to Sale) which isn't, it should work the same way as the Insurer Click to Sale table above. I know I can get it to work by creating another table specifically for source like I have done wirh Insurer but I dont feel this should be necessary, can anyone help?


I'm not clear about your requirement. Could you please clarify more details about why does visual "Source Click to Sale" not working fine? And could you clarify which columns are contained in the visuals?

 

Regards,

Jimmy Tao

Anonymous
Not applicable

1) The top left visual - lists insurers & the subsequent sales count for each of these from the Business_Confirmed table

2) The top-middle visual - lists insurers & the subsequent quote count from the Business_Full_Quote table

3) The top right visual - calculates the quote to sale based on a measure = SalesCount/QuoteCount 

4) The bottom left visual - lists the Price Comparison websites & the subsequent quote count for each of these from the Business_Full_Quote table.

5) The middle-bottom visual - lists the Price Comparison websites & the sales count for each of these from the Business_Confirmed table

6) The bottom right visual is not working correctly - it displays the list of Price Comparison websites but doesnt perform the quote to sale, I am using the same measure. 

 

Hopefully this is enough information. 

jthomson
Solution Sage
Solution Sage

You've not given us any information to work off, and a thread title of "Power BI help" is equally undescriptive - you say it's not working, show us some data, what the table is doing, and what it ought to be doing

Anonymous
Not applicable

haha,

1) The top left visual - lists insurers & the subsequent sales count for each of these from the Business_Confirmed table

2) The top-middle visual - lists insurers & the subsequent quote count from the Business_Full_Quote table

3) The top right visual - calculates the quote to sale based on a measure = SalesCount/QuoteCount 

4) The bottom left visual - lists the Price Comparison websites & the subsequent quote count for each of these from the Business_Full_Quote table.

5) The middle-bottom visual - lists the Price Comparison websites & the sales count for each of these from the Business_Confirmed table

6) The bottom right visual is not working correctly - it displays the list of Price Comparison websites but doesnt perform the quote to sale, I am using the same measure. 

 

Hopefully this is enough information. 

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

February Power BI Update Carousel

Power BI Monthly Update - February 2026

Check out the February 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.