Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
danjdo
Frequent Visitor

Comparing values based on slicer selections

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. 

 

 

image.png

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 REPLY 1
shishir999
Helper II
Helper II

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors