Compare same month with last year's month

[Raghda_Alshehhi]

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. 

[Raghda_Alshehhi]

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]

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]

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

[lbendlin]

There is a "100% Stacked Column" visual - you can try that.

Do you have a general idea of what your expected result should look like? Can you show a mockup?

[lbendlin]

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]

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]

Here is an example 

If you like more help please provide sample data.

[Raghda_Alshehhi]

I've placed the PBX file in drop box as i can not yet upload any file directly

https://www.dropbox.com/s/1khilumf0p90mec/SAMPLE.pbix?dl=0

[lbendlin]

Here would be an example of the conditional formatting with icons

Adjust as needed. see attached.

[Raghda_Alshehhi]

Thank you very much for your response!!

much appreciated. 
may I ask one last thing, will the up/down arrow will show if i converted this to bar or visual graph ?

[lbendlin]

The availability of icons for conditional formatting varies between visuals.  It may not be available for the standard Column chart (bar chars are horizontal) but there might be custom visuals that allow that.

Instead of the icons you can also use column color ( for example)  for the visual indication of the trend.