Forum Discussion

nonoFRissy85's avatar
nonoFRissy85
Regular Visitor
3 years ago
Solved

Measure or count in Y Axis

Hi   i wanted to put in a bar chart on Y Axis a number of stores on X Axis  a number of products and so having the number of stores for each number of products   on X Axis i can put my field "...
Need Help
  • Barthel's avatar
    Barthel
    3 years ago

    nonoFRissy85,

    Ah thanks, now I get it. I have a possible way how you could present this in a bar chart (not sure if this is the most optimal method).  

    1. Add a parameter table to your model.
    2. Place the parameter column on the y-axis. This column refers to the number of different products (1, 2, 3, etc)
    3. Create a new measure, where you count the number of stores for every number of different products it sells.

     

     

    Nb of stores =
COUNTROWS (
    FILTER (
        DISTINCT ( 'Table'[Store] ),
        VAR _store = 'Table'[Store]
        VAR _product =
            SELECTEDVALUE ( Parameter[Parameter] )
        VAR _products =
            CALCULATE (
                DISTINCTCOUNT ( 'Table'[Product] ),
                REMOVEFILTERS ( 'Table' ),
                'Table'[Store] = _store
            )
        VAR _result = _products = _product
        RETURN
            _result
    )
)
​

     

    Place the measure on the x-axis and this is your result:

Barthel's avatar
Barthel
Icon for Solution Sage rankSolution Sage
3 years ago

Hey nonoFRissy85,

The y-axis must be a categorical variable. So you can show the number of products per store. Or the number of stores per product. Not the number of stores per the number of products.

You could also show the total number of stores and total number of products at the same time by placing them both on the x-axis. The distinction is then made by means of a legend. But it is just one value for store and one value for products.