Bar Chart Help

[Anonymous]

Is there a visual in Power BI that I can use to achieve the below report that I have prepared in excel?

Daily, WTD and average

Thanks 

[v-kelly-msft · Accepted solution]

Hi  @Anonymous ,

First create a column in your fact table:

Month-day = FORMAT('Table'[date],"DD-MMM-YY")

Then create a dim table as below:

Table 2 = UNION(VALUES('Table'[Month-day]),ROW("name","WTD actual"),ROW("name","WTD Target"))

And a date table as below:

Date = CALENDAR("2021-1-1","2021-12-31")

Then create a measure as below:

Measure =
VAR _mindate =
    MINX ( ALLSELECTED ( 'Table' ), 'Table'[date] )
RETURN
    SWITCH (
        SELECTEDVALUE ( 'Table 2'[Month-day] ),
        "WTD actual",
            CALCULATE (
                SUM ( 'Table'[amount] ),
                FILTER (
                    ALLSELECTED ( 'Table' ),
                    'Table'[date] >= _mindate
                        && 'Table'[date] <= _mindate + 6
                )
            ),
        "WTD Target", 375466,
        SUM ( 'Table'[amount] )
    )

And you will see:

For the related .pbix file,pls see attached.

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!

[Pragati11]

HI @Anonymous ,

You can use a Line and Clustered Column chart in Power BI to represent 2 metrics with common x-axis.

Something like below:

Thanks,

Pragati

[Anonymous]

okay, so is impossible to have the WTD, daily, and average all on the same chart right

[Pragati11]

HI @Anonymous ,

In what format your data is, it depends on that as well.

Can you share some sample data here?

Thanks,

Pragati