Forum Discussion

Raghda_Alshehhi's avatar
Raghda_Alshehhi
Frequent Visitor
4 years ago

Compare same month with last year's month

Hi,

Can anyone please, help me with my visualization? some of my coullegues have said that its confusing to understand the graph percentage change? i don't know where to apply the conditional formatting here. 

Is there any sugeestion to make it more readble and better looking? Specially if i want to highlight the +/- changges?

Also, what if i try to show the total per month within same month 

the problem i have growing data, and it gets very crowded when i try to do that? 

 

this is the dax i used to create the month% change: 

YOY % =
VAR PY =
    CALCULATE(SS[Total MVT],DATEADD('SS'[Date].[Date],-1,YEAR))
RETURN
    DIVIDE(('SS'[Total MVT]-PY),PY)
 
I\ve attached a sample pic, since I can not upload any file, and i cannot share the data to Dropbox becasue of work restrictionsw. 
 
 
DAX

11 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    Keep experimenting with different visuals.  Oftentimes for YoY comparisons a table or matrix visual with icons (up/down/sideways arrow for example) is more appropriate.

    • Raghda_Alshehhi's avatar
      Raghda_Alshehhi
      Frequent Visitor
      3 years ago

      Can we add icons arrows for this kind of visuals? If yes I will appreciate if you can explain it to me? 
      where I can find arrows and present this in more appropriate way?

      • lbendlin's avatar
        lbendlin
        Super User
        3 years ago

        Here is an example 

         

        If you like more help please provide sample data.

  • Raghda_Alshehhi's avatar
    Raghda_Alshehhi
    Frequent Visitor
    3 years ago

    Thank you again for your help.

    One last thing,  When i created a coloumn chart, when the percentage is very low, the value is not apprering in the vistuialization. I tried to resize it, but did not know how to show all the values in the graph e.g Apr 2022. How i can make sure all my figures apprears even for small totals,margins e.g, 00.76%

     

    Also, for the conditional formating of the table, what if i simply want to show up/down positive/negetive arrow only (red,green)? means when it has (negitive sign) it means red a drop,, when it's not negetive it means green (I'm comparing same month over the years) 

    • lbendlin's avatar
      lbendlin
      Super User
      3 years ago

      You have a couple of options. You can create a "Month over Month To Date" measure that compares same time intervals. Another option is to use 100% stacking.

      You can choose to show only the icons and hide the values.

      • Raghda_Alshehhi's avatar
        Raghda_Alshehhi
        Frequent Visitor
        3 years ago

        What i mean for the stacked colomn chart, not values are showing becuase for example April 2022 value is 43.07% (please refer to the sampe PBX) is there any way to make sure i have all the numbers appreasing like resizing the bar chart or sth? 

        Also, i'm stuck with +/- formatting, how can i show any number with negetive sign as red, and anything else green? 

        Sorry for the inconvinience, im very new to Power BI