Comparing values based on slicer selections

danjdo — Thu, 29 Nov 2018 17:08:42 GMT

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

Re: Comparing values based on slicer selections

shishir999 — Fri, 30 Nov 2018 06:06:45 GMT

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.

topic Comparing values based on slicer selections in Developer

Comparing values based on slicer selections

Re: Comparing values based on slicer selections