Forum Discussion
Compare same month with last year's month
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)
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.
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
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?
