Forum Discussion

SammyNed's avatar
SammyNed
Helper I
2 years ago
Solved

Graph with only specific columns showing

Good Day

 

It is possible to have a graph in powerbi showing 3 (or more months), but only showing the target/forecast data for the current month?

 

raw data is similar to the below, Actual, Forecast and Target per month.

 

Final graph to look as below, only showing all 3 data points for the current month, and only the actual data for previous months. The reason is to make the graph look less cluttered and only show the valuable data points (i.e no need to see the target from 2 months ago but we want to see the trend of the actuals over).

 

Is this possible

 

Thank you in advance

 

  • KeyurPatel14's avatar
    KeyurPatel14
    2 years ago

    Hello SammyNed ,

    Hope you are doing well.

     

    Kindly find the dataset I created:

    Measures:

    Result:

    If this helps, then kindly give it a kudos and mark it as a solution.

    Best Regards,
    Keyur Patel

5 Replies

  • SamInogic's avatar
    SamInogic
    Super User
    2 years ago

    Hi SammyNed 

    As per our understanding, you want the Actual, Forecast, and Target need to be display to get a trend on the power BI report, so we could suggest to use Line chart where you can compare these Actual, Forecast, and Target by each month.


     

    Thanks!

    Inogic Professional Service Division

    An expert technical extension for your techno-functional business needs

    Power Platform/Dynamics 365 CRM

    Drop an email at [email protected]

    Service:  http://www.inogic.com/services/ 

    Power Platform/Dynamics 365 CRM Tips and Tricks:  http://www.inogic.com/blog/

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi SammyNed ,

    I create a table as you mentioned.

    Then I create two measures and here are the DAX codes.

     

    Forecast Measure = IF(SUM('Table'[Forecast])=286,286,0)

Target Measure = IF(SUM('Table'[Target])=256,256,0)

     

    Finally I put them into the Clustered column chart and it gives the result you want.

     

     

     

    Best Regards

    Yilong Zhou

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • SammyNed's avatar
      SammyNed
      Helper I
      2 years ago

      hi Anonymous 

       

      This appears to be on the right track, however its not dynamic. Is it possible to include a filter to say only show the forecast data if it occurs within the current month. i know i can use EOMonth, but unsure how to incoroprate it

      Forecast Measure = IF(SUM('Table'[Forecast])=CurrentMonth,forecast,0))

       

  • KeyurPatel14's avatar
    KeyurPatel14
    Responsive Resident
    2 years ago

    Hello SammyNed ,

    Hope you are doing well.

     

    Kindly find the dataset I created:

    Measures:

    Result:

    If this helps, then kindly give it a kudos and mark it as a solution.

    Best Regards,
    Keyur Patel