Forum Discussion

GoncaloCare's avatar
GoncaloCare
Helper I
5 years ago
Solved

Calculate Marketshare - Help

Hi. I need some help building a table with marketshare values. So, imagine I have this table:   Year-Month Brand Value Jan'21 A 45 Jan'21 B 35 Jan'21 A 76 Jan'21 C 465 ...
Need Help
Jihwan_Kim's avatar
Jihwan_Kim
Super User
5 years ago

Hi, GoncaloCare 

Thank you for your feedback.

I am not sure about how is the limitation of showing how many categories (or legends) in a linechart.

I also sometimes face a similar situation as what you just described.

However, if I see over 20 lines in one line chart, I don't think it creates values or insights for readers. Or, perhaps you can try to select other visualizations, like a scatter chart for instance, if you need to show more than 20~30 categories.

Thank you.

GoncaloCare's avatar
GoncaloCare
Helper I
5 years ago

Hi Jihwan_Kim 

Thank you very much again. Sadly, it doesn't show all brands. Do you know any way to group brands? For example, in the table I provided, grouping A and C to "Other" group. 

Is it possible?

 

 

Thanks!

Best Regards.

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    5 years ago

    Hi, GoncaloCare 

    Thank you for your feedback.

    If you just want to group those two, you can simply create a hierarchy table.

    Or, do you want to dynamically group? For instance, below 50% goes to "Others", and shows the rest? This is also doable if you have a rule about how to group those.

    If it is OK with you, please share your sample pbix file's link here, and give instructions about how to group. Then I can try to look into it to come up with a more accurate solution.

     

    Thank you.