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, Forec...
  • 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

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/