Dynamic Parameter

[Anonymous]

Hello,

I am brand new to Power BI and have been looking around the forum and can't seem to find the answer to this scenario. 

I am transitioning from Tableau to Power BI and to improve performance, I calcuate all my YTD, MTD measures prior to loading in Power BI.  I  am trying to set up something similiar to what I have below.  If the user wants to see YTD Volume- They select a Parameter String named YTD and that triggers the dashboard to display the YTD Volume Measure. 

Is there a way to achieve a similair set up in Power BI?  Thanks

[jdbuchanan71 · Accepted solution]

@Anonymous 

You can write a measure to read a user selection from a table (your list of time periods) and display a different measure depending on the user selection.

Your [Time Periods] table would look like this.

Time Period

YTD

Rolling 13 Weeks

2019

MTD

The the measure to read the user selection and swtich the dispalyed value will be like so.

Selected Period Volume =
VAR _TimePeriod =
    SELECTEDVALUE ( 'Time Periods'[Time Period] )
RETURN
    SWITCH (
        _TimePeriod,
        'YTD', [YTD Volume],
        'Rolling 13 Weeks', [Rolling 13 Week Volume],
        '2019', [2019 Volume],
        'MTD', [MTD Volume]
    )

[aj1973]

Hi @Anonymous 

Yes there is a way. I am not familiar with Tableau but according to your description you can achieve what you want by using Bookmarks or Drillthrough with Power Bi.

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drill-through-buttons

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-bookmarks

Or maybe if you can share Pibx file to help the community to better understand your issue

Regards