Forum Discussion
Helper ICalculate Marketshare - Help
Hi, GoncaloCare
Please check the below picture and the sample pbix file's link down below.
Percentage by month =
IF (
ISFILTERED ( 'Calendar'[Year-Month] ),
DIVIDE (
SUM ( Data[Value] ),
CALCULATE ( SUM ( Data[Value] ), ALLSELECTED ( Brands[Brand] ) )
)
)https://www.dropbox.com/s/czwzog2rny4zypo/goncalocarre.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Helper IHi again Jihwan_Kim !
So, it's working great!
I have a question. In the line chart, I have 188 Brands, but only like 30/50 are showing. Do you know why that is happening? is that a limitation?
Thanks!
Super UserHi, 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.