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 format...
DAX
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

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    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?