Add data in a clustered column chart without modifying data source

Anonymous ,

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

Hi Anonymous ,

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.