Forum Discussion

yanisyes's avatar
yanisyes
Frequent Visitor
4 years ago
Solved

Add data in a clustered column chart without modifying data source

Hello,   I've created the column stacked graph below    My measure is just a simple Calcultate(countrow(mytable)), and I've put the sub category as column serie. WHat I want to do it to mo...
Need Help
  • Arul's avatar
    Arul
    4 years ago

    yanisyes ,

    I hope the below is your expected output, this can be achieved by writing one measure like the below by modifying it based on your data,

     

    Sales Feb = IF(SELECTEDVALUE(financials[Month Name])="February",financials[Sales]+30000000,financials[Sales])

     

    use this in your visual

    Thanks,

    Arul

     

  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi yanisyes ,

    Please refer to my pbix file to see if it helps you. 

    Create a measure.

    Measure =
VAR _month =
    MONTH ( MAX ( 'Table'[date] ) )
VAR _year =
    YEAR ( MAX ( 'Table'[date] ) )
RETURN
    CALCULATE (
        COUNTROWS ( 'Table' ),
        FILTER (
            ALL ( 'Table' ),
            MONTH ( 'Table'[date] ) = _month
                && YEAR ( 'Table'[date] ) = _year
                && 'Table'[sub-category] = SELECTEDVALUE ( 'Table'[sub-category] )
        )
    )

     

    If I have misunderstood your meaning, please provide your pbix file without privacy information and desired output with more details.

     

    Best Regards

    Community Support Team _ Polly

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

yanisyes's avatar
yanisyes
Frequent Visitor
4 years ago

Hi Arul, 
First thanks for your answer but all my data are not in column like in your case so I can't do the thing you are suggesting + if I have two measure in the columns values ( means no column serie). I will not be able to click only on forecast or actual or baseline for the month selected.
WHen I will try to click it will only filter the month with all my data (it will display forecast baseline, actual of February if I click on forecast for the month of february). 
THis is why I've created only one measure 

Here is my data

My measure is counting the number of time the month appear for each subcategory and I want to delete the forecast of the milestone  3 in feb to change my chart from this 

TO this

 

THanks.