Parameter Filter

Question

Hello all, looking for assistance creating a parameter filter or slicer so a user can dispay rows with a certain category or option selected.&nbsp; The report consists of 2 tables next to eachother.The example scenario details include:- User needs to have a slicer/parameter that only has options for Radio, Sunroof, and P Locks.&nbsp;- The 2 tables are being generated from 2 different queries.- There is not a relationship between these 2 queries.- The output of the queries are like below.&nbsp;Left Query Results&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Right Query ResultsTypeColorDealer LocationRadioSunroofP Locks&nbsp;&nbsp;TypeColorCustomer LocationRadioSunroofP LockscarredKansas110&nbsp;&nbsp;truckblackNebraska010truckgreenTexas100&nbsp;&nbsp;truckredCalifornia101caryellowUtah111&nbsp;&nbsp;carblueMaine001carpurpleTexas000&nbsp;&nbsp;TruckblueFlorida000&nbsp;- If the user selects Radio the desired output would be&nbsp;Left Result&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Right ResultTypeColorDealer Location&nbsp;TypeColorCustomer LocationcarredKansas&nbsp;truckredCaliforniatruckgreenTexas&nbsp;&nbsp;&nbsp;&nbsp;caryellowUtah&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;I realize that I could modify the queries so that the Radio, Sunroof, and P Locks columns would be in the same column and then have an increased amount of rows, then use slicers but I would like to learn how to use parameters for something like this.&nbsp; This is easily done in Tableau and that is the route I took it due to time restraints but would like to understand how I could do it in Power BI.

anonymous · Accepted Answer

Hi&nbsp; thebigrlebowski&nbsp;,
&nbsp;
&nbsp;
Here are the steps you can follow：
1. Enter data.

2. Create measure.
&nbsp;
Flag1 =
var _select= SELECTEDVALUE('Slicer_Table'[Group])
return
SWITCH(
    TRUE(),
    _select="Radio" &amp;&amp; 1 in SELECTCOLUMNS('Left Query Results',"Radio",'Left Query Results'[Radio]),1,
    _select="Sunroof" &amp;&amp; 1 in SELECTCOLUMNS('Left Query Results',"Sunroof",'Left Query Results'[Sunroof]),1,
    _select="P Locks" &amp;&amp; 1 in SELECTCOLUMNS('Left Query Results',"P Locks",'Left Query Results'[P Locks]),1,
0)Flag2 =
var _select= SELECTEDVALUE('Slicer_Table'[Group])
return
SWITCH(
    TRUE(),
    _select="Radio" &amp;&amp; 1 in SELECTCOLUMNS('Right Query Results',"Radio",'Right Query Results'[Radio]),1,
    _select="Sunroof" &amp;&amp; 1 in SELECTCOLUMNS('Right Query Results',"Sunroof",'Right Query Results'[Sunroof]),1,
    _select="P Locks" &amp;&amp; 1 in SELECTCOLUMNS('Right Query Results',"P Locks",'Right Query Results'[P Locks]),1,
0)
&nbsp;
3. Place [Flag1] and [Flag2] into Left Query Results and Left Query Results respectively.
For example, [Flag1].
Place [Flag1]in Filters, set is=1, apply filter.

4. Result:

&nbsp;
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
&nbsp;

Forum Discussion

Parameter Filter

2 Replies

Related content

Parameter in summarize

Using parameters to filter to desired number of rows

Filter Field Parameter by Field Parameter Values without Calculated Groups

notebook parameter

Parameters to fabric pipeline

Type	Color	Dealer Location	Radio	Sunroof	P Locks	Type	Color	Customer Location	Radio	Sunroof	P Locks
car	red	Kansas	1	1	0	truck	black	Nebraska	0	1	0
truck	green	Texas	1	0	0	truck	red	California	1	0	1
car	yellow	Utah	1	1	1	car	blue	Maine	0	0	1
car	purple	Texas	0	0	0	Truck	blue	Florida	0	0	0