Forum Discussion

spartanboy's avatar
spartanboy
Helper II
4 years ago
Solved

Column chart to show difference %

Hello - Any charts that is recommended to show  the difference in % for 2 columns below, here the result should be -3.7%     TIA  
  • amitchandak's avatar
    4 years ago

    spartanboy , I such we need measures like

     

    MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))


    last year MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-12,MONTH)))
    Previous year Month Sales = CALCULATE(SUM(Sales[Sales Amount]),previousmonth(dateadd('Date'[Date],-11,MONTH)))
    last year MTD (complete) Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(ENDOFMONTH(dateadd('Date'[Date],-12,MONTH))))

     

    diff = [MTD Sales]-[last year MTD Sales ]
    diff % = divide([MTD Sales]-[last year MTD Sales],[last year MTD Sales])

     

     

    If need you can put all three into a calculation group

    Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0

     

     

    Power BI — Month on Month with or Without Time Intelligence
    https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e
    https://www.youtube.com/watch?v=6LUBbvcxtKA