Forum Discussion

ashraf_martin's avatar
ashraf_martin
Regular Visitor
2 years ago

Clean and simple Dashboard Design

I'm trying to create this view in Power Bi, i created the calulation groups based on Time series.

for the design i want to have for each interval (Yesterday, WTD, MTD, ect) sales and margin at the top and then i want to have in rows vs BP (Budget) the value variance and below that the % variance and the same for FC (Forecast) and LY (Last Year).

below is a screenshot sample.

 

 

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    2 years ago

    ashraf_martin , With two calculation groups with additional calculated columns, we should be able to something similar

     

    Check this out

    Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0