Forum Discussion

junoglasgow's avatar
junoglasgow
Frequent Visitor
7 years ago

Market share by cateogory

 

I wish to make a Bar chart only showing specific brand M/S by category. Dataset consists as following;

 

Data name: Market

Column1: 5 Market Segment category

Column2: Brand with the list of several company brands

Column3: Year, just want to see 2018

 

Your help would be much appreciated!! 

4 Replies

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    7 years ago

    Hi junoglasgow,

     

    Without any data is difficult to give you a specif response however you can do a filter on any visual on 3 different ways:

    • Creating a slicer for each column you want to filter in this case Brand and Year
      • If you don't want user to change it after making the selections on the slicers hide them
    • Adding the columns Brand and Year on visual level filter and selecting the values you need
    • Creating a measure with the filters and using it as the values on your bar chart 
      Measure =
CALCULATE (
    SUM ( Table[column] );
    Table[Brand] = "Brand A";
    Table[Year] = 2018
)

     

    Be aware that creating the measure will make the values fix and to change them you need to change your report on the other options it's more flexible in terms of changing the selections.

     

    Again without additional information is difficult to give you a better response.

     

    Regards,

    MFelix

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi junoglasgow

    From your another post which is related to this one,

    https://community.powerbi.com/t5/Desktop/Market-share-by-category/m-p/538667

     

    How do you calculate the percentage?

     Chart1 BrandA    Chart2 BrandB   Chart3  BrandC    Chart4 BrandD
    Entry 12%   Entry 13%   Entry 14%   Entry 11%
    Main 13%   Main 15%   Main 13%   Main 10%
    High 22%   High 24%   High 24%   High 27%
    Premium 1%   Premium 2%   Premium 11%   Premium 11%
    Luxury 6%   Luxury 5%   Luxury 62%   Luxury 16%

     

    I make a test based on your table as below, but it seems not like yours.

    Measure-> total Qty per Brand and per Market Segment, for example, for Luxury, total Qty for Brand A is 11

    Measure2-> total Qty per Market Segment, for example, for Luxury, total Qty for all Brands is 29

    Measure3->Measure/Measure2

     

    Also Rank1 Brand~Rank4 Brand, and Brand A market share 74% in Entry / Brand A Market share 34% in Luxury / 85% market share in Premium are not clear to me.

    (I made it as guided but it only shows % of Grand total. I want to see % of subtotal for a specific brand.

    For example, Brand A market share 74% in Entry / Brand A Market share 34% in Luxury / 85% market share in Premium etc..)

     

    Could you tell me how to calculate these percentage?

     

    Best Regards

    Maggie

      • v-juanli-msft's avatar
        v-juanli-msft
        Icon for Community Support rankCommunity Support
        7 years ago

        Hi junoglasgow

        Create measures to get the percentage you'd like

        per brand = CALCULATE(SUM(Sheet1[Qty Sold]),ALLEXCEPT(Sheet1,Sheet1[Brand]))

PerMarket PerBrand = CALCULATE(SUM(Sheet1[Qty Sold]),FILTER(ALLEXCEPT(Sheet1,Sheet1[Market Segment]),[Brand]=MAX([Brand])))

MarketShare(%) ByBrand = [PerMarket PerBrand]/[per brand]

        How do you create the bar chart? Is my bar chart right? This means which columns or measures you want to add in fields of bar chart?

         

         

        Best Regards

        Maggie