Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello, I am very new to Power BI and find some tasks difficult.
I have a single table with multiple forecasts that are timestamped (in this example simplified to just be called forecast 1, 2 etc.). Each forecast will contain the forecast periods (date, year, month).
I need the user to choose two forecast periods (most likley via two seperate drop downs) and then have a chart and table compare the two forecast periods.
Example: Dropdown 2 user chooses Forecast 2, Dropddown 1 user choose Forecast 1.
Chart shows line graph with the two forecasts, value over month/year
then a table that caclulates the delta between each of the year/month values.
I've looked online for about 3 hours but can't seem to find a solution. This is something that would take 10 minutes in Excel but seems much more complicated in Power BI.
Please help. I am on my knees!
Daniel
1. Try by Creating a duplicate dataset.
2. Display the value on the table chart from both dataset.
3. Add 2 slicers ie. 1st as from 1st dataset and 2nd from duplicate dataset on Forecast field.
SG
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
2 | |
2 | |
1 | |
1 |