cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
danjdo Frequent Visitor
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
Highlighted
shishir999 Regular Visitor
Regular Visitor

Re: Comparing values based on slicer selections

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