Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Dashboard Idea

i am having Findata , BudgetData as fact tabel ,

in that fact table Date, LedgerName, Group Name and Amount

in that how do we make the following dashboard in power bi , PLEASE GIVE SOME IDEA

1.Month

2.Up to Current Month

3.Full Year

 111 222 333
 Current YearLast YearBudget Current YearLast YearBudget Current YearLast YearBudget
Revenue           
Gross Profit           
Gross Profit %           
Net Profit           
Net Profit %           
Tips and Tricks

5 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    Anonymous , You need to use calculation groups

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      where i made mistake , not in order also (revenue,Gross Profit, Gross Margin , Net Profit , Net Margin)

      and applied "0.00%" format string for Margin Calculation, but it is also not displayed , please help

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      where i made mistake , not in order also (revenue,Gross Profit, Gross Margin , Net Profit , Net Margin)

      and applied "0.00%" format string for Margin Calculation, but it is also not displayed , please help

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      now i understood thank you very much

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    HI thank you very much . but i have some doubts

    two fact table 1.Findata ,2. Budget   . findata . i am having revenue , grossprofit and gross margin measure . the same name i need budget column also . and want to insert blank column and blank row , please guide