Forum Discussion

Tairo's avatar
Tairo
Helper 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 don't show.

 

Properly I refer in my measure to the date column. Is there a way to visualize actual and previous values in a bar graph?

 

I added a link to an example:

 

Example

 

Tairo

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.

7 Replies

  • MFelix's avatar
    MFelix
    Super User
    8 years ago

    Hi Tairo,

     

    When looking at you model everything is working properly.

     

    The question is that when you refer to prior month are you refering to prior month itself or aopriormonth with data meaning:

    In april do you want to see March values (that you don't have data) or February data?

     

    Regards,

    MFelix

    • Tairo's avatar
      Tairo
      Helper I
      8 years ago

      Hi MFelix,

       

      Thanks a lot for your response.

       

      The formulas are working fine,

       

      I am collecting a large number of customer remarks for different categories. I am trying to build a dashboard that gives a warning when there is a large increase of customer remarks compared to a previous period. As an indication that there might be something wrong with categoires that exceed a certain value.

       

      So to answer your question I like to the month itself, meaning: When there are no values in March I still want to compare April to March. But when I place PrevMonthValue in a graph, the values are not visible.

       

      Regards,

       

      Tairo

      • MFelix's avatar
        MFelix
        Super 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?