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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Q007
Helper I
Helper I

Slicer

Hi,

I'd like to create a combo chart to display quantity and market share of sold cars, split by brand and mark in each country.

I have one slicer for country, one for brand, one for make and one for cars sold/ Market share columns.
I don't know why but when I select a country, brand and make  from the slicers, I can't use a combo chart to display market share and sold cars for each country, brand and mark. In other words, I can't attribute unit sold to "column values" and market share to "line values" of visualisations pane.

RegionCountryBrandMarkClinderUnit sold/Market share
Sub-Saharan AfricaMozambiqueAudiQ360.11
Sub-Saharan AfricaMozambiqueAudiQ360.12
Sub-Saharan AfricaMozambiqueAudiQ360.12
EuropeBosnia and HerzegovinaAudiQ560.12
Sub-Saharan AfricaMozambiqueAudiQ360.15
EuropeBosnia and HerzegovinaAudiQ560.19
EuropeBosnia and HerzegovinaAudiQ560.23
Sub-Saharan AfricaMozambiqueAudiQ360.23
Sub-Saharan AfricaMozambiqueAudiQ360.33
EuropeBosnia and HerzegovinaAudiQ560.34
Sub-Saharan AfricaMozambiqueAudiQ360.43
Sub-Saharan AfricaMozambiqueBenzA60.43
EuropeBosnia and HerzegovinaBMWM360.45
EuropeBosnia and HerzegovinaAudiQ560.56
EuropeBosnia and HerzegovinaAudiQ560.67
Sub-Saharan AfricaMozambiqueBenzA40.32
EuropeBosnia and HerzegovinaBenzC428006
EuropeBosnia and HerzegovinaAudiQ3430823
Sub-Saharan AfricaMozambiqueBenzA443489
Sub-Saharan AfricaMozambiqueBMWQ7648229
Sub-Saharan AfricaMozambiqueAudiQ3657698
Sub-Saharan AfricaMozambiqueAudiQ3659495
Sub-Saharan AfricaMozambiqueAudiA3467127
EuropeBosnia and HerzegovinaBMWM3467603
EuropeBosnia and HerzegovinaAudiQ5473876
EuropeBosnia and HerzegovinaAudiA3481037
Sub-Saharan AfricaMozambiqueAudiA4488523
EuropeBosnia and HerzegovinaBenzA488857
Sub-Saharan AfricaMozambiqueBMWM5690850
EuropeBosnia and HerzegovinaAudiQ5699741
EuropeBosnia and HerzegovinaAudiQ56169624
EuropeBosnia and HerzegovinaAudiA44236411
4 REPLIES 4
v-eachen-msft
Community Support
Community Support

Hi @Q007 ,

 

You could use this combo visual --- line and clustered column chart.

And you could share some visual screenshots to show the issues.

1-1.PNG

 

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.

Thanks,

I am affraid but it wasn't helpful as I see  "column" on the legend which the key to my problem. Could you let me know how did you calculate it?

 

Hi @Q007 ,

 

The "column" is like your "market share". It is a column filled with some values. I put it to the "line values" as you mentioned in the question.

 

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.

Thanks,

Actually I could duplicate sold cars and market share column and call the coppied column "market share", I should be able to solve the problem. Shouldn't I? 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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