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

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))