Forum Discussion

ditoparker's avatar
ditoparker
New Member
1 year ago
Solved

Using a parameter to filter my visual

Hello! for context, I am veteran Tableau user on his first week using Power BI so apologies in advance if I am approaching this the wrong way. I have one column with the values: Joe Joe Everyon...
Need Help
  • ullassl1991's avatar
    ullassl1991
    1 year ago

    Hi ditoparker , I have taken some sample of data based on your explination like this table Sheet1

     

    I just worked on this data I have a solution on your requirement
    Step1: Create a unrelated table "Selection" with this strings

    Step2: Create the follwing measure to assign values to those selections

    Measure = SWITCH(
    SELECTEDVALUE(Selection[Name]),
    "Joe",SUM(Sheet1[work]),
    "Everyone",CALCULATE(SUM(Sheet1[work]),Sheet1[name]="Everyone"))

    Step 3 
    This is the actual value of work as per the table

    its showing Everyone=81, Joe=11, Total=92
    Now take the "Name" column from Seletion table and take the measure created into card

     

    we can see overall value is shown under Joe and remaining value shown under everyone
    I hope it gives the solution you want , let me know
    Thank you



d_m_LNK's avatar
d_m_LNK
Super User
1 year ago

A simple thing to start with would be a slicer visual and adding the referenced column to that visual.  This will filter the entire page by what you select in the slicer.  That will allow you to select either value from that column and filter the page in that way.  I am less clear about the "Joe" option as that seems to be more related to the rest of the table data or the data model for filtering behavior.  There is a select all option in the slicer visual as well you can toggle on.