Forum Discussion

Tairo's avatar
Tairo
Icon for Helper I rankHelper I
8 years ago
Solved

cannot visualize previous month values in graph

I created a measure to calculate values of the previous month. But when I want to use a clustered bargraph to compare actual values and those of the previous month, the values of the previous maonth ...
Need Help
  • Tairo's avatar
    Tairo
    8 years ago

    MFelix,

     

    Thanks, that was the solution I was looking for.

     

    Unfortenately the conditional formating of power bi don't allow if statemens so I used formula below to change the words.

     

    Label = if ('TableName'[Perc. Diff] >= 0.2 || 'TableName'[Perc. Diff] <= -0.20, "divergend", "standard" )

  • MFelix's avatar
    MFelix
    8 years ago
    In conditional format you need to select the use formula in the setup it will allow you to make several ifs.
MFelix's avatar
MFelix
Icon for Super User rankSuper User
8 years ago
Hi,

I have made a chart using the date (month) and values column and pv month measure and it worked well. For example in February it shows 85 in pv month so matching january.

How are you placing the columns / measures on your chart?
Tairo's avatar
Tairo
Icon for Helper I rankHelper I
8 years ago

Hi MFelix,

 

Did you made chart in the example file?

 

When possible I like to create a clustered bar graph with on the x-axis the categories and on the y-axis the #. As values I want to use actual month and previous month.

 

Next I am placing date, catgory, actual and previous value, difference in a table. I want to use conditional formating to make the background color red when the differece exceeds a certain value.