Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello,
I am a beginner, I wish to compare actual vs budget sales but can't get it to work. My actual and budget numbers are both in the same table, along with the regions (one large excel sheet), could this be the problem ?
Here is my table
My selections are :
Thank you for your help !
Solved! Go to Solution.
@debutant , Having them in one sheet is not a problem. Not if there is a column type (Actual/budget) and Value. then you need measures
Actual= calculate(Sum(Table[Value]), filter(Table, Table[Type] ="Actual"))
Budget= calculate(Sum(Table[Value]), filter(Table, Table[Type] ="Budget"))
Create a date table and other dimensions as per need
refer first 5-6 video of the series , I have discussed breaking of a large table
Power BI Tutorial Series for Beginners: https://www.youtube.com/watch?v=wvsAzTqSDVg&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb
thank you, this worked perfectly.
I would like to make YTD comparison vs. prior year, I have written this measure but am stuck because it always shows the full year, I don't know how to make it so that it would only show the same period values as Current year sales, not the entire year. (surrent year woul be defined from a slicer)
@debutant , Having them in one sheet is not a problem. Not if there is a column type (Actual/budget) and Value. then you need measures
Actual= calculate(Sum(Table[Value]), filter(Table, Table[Type] ="Actual"))
Budget= calculate(Sum(Table[Value]), filter(Table, Table[Type] ="Budget"))
Create a date table and other dimensions as per need
refer first 5-6 video of the series , I have discussed breaking of a large table
Power BI Tutorial Series for Beginners: https://www.youtube.com/watch?v=wvsAzTqSDVg&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb
User | Count |
---|---|
123 | |
70 | |
67 | |
58 | |
53 |
User | Count |
---|---|
183 | |
92 | |
67 | |
62 | |
52 |