Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Slider with the values in a Matrix Table

Hello.

I have an issue with my current Power BI module. I have created a matrix table. In this table I have put the a column called population in households. I then created a parameter with a slider that is a percentage between 0%-100%. The Parameter is called Population When I created a measure called Adjusted Weighted Population. The formula went like this Adjusted weighted Population=Sumx(all_states_mobility, all_states_mobility[Population in households] * )1+Population[Population Value]. I then created a new column called Adjusted Population. The formula for that column goes like this 

Adjusted Population = All_states_Mobility[Adjusted weighted Population]. 
 
What confuses me, is when I go to the matrix table and try add the adjusted population column and change the slider nothing happens, all the values are fixed to the original values of the population in households columns. However if I add the measure weighted adjusted population, I can adjust the slider and watch the values change. Can anybody explain to me why it works like this, and how I can columns to react to sliders like this moving forward?

 

What I am trying to accomplish is to be able to change the value on the slider and have the values in the column on the matrix table change as well. The purpose of a slider is to demonstrate the weight of a category such as Population in Households. I plan on creating slider as weights for other categories but need to figure out how this works. Please let me know.

1 Reply

  • ValtteriN's avatar
    ValtteriN
    Icon for Community Champion rankCommunity Champion
    2 years ago

    Hi,

    Here is how I would approach these kind of custom slicers:

    Demo data:

    Now in my example I will filter the values which are greater than 0.7 when multiplied by two. This is different than in your example, but the way I will create this slicer can be applied to your case as well.


    Slicer:

    Dax:

    Filter measure for matrix = IF(MAX('Table (17)'[Value])*2>[Filter for values greater than this Value],1,0)



    Now we will place this measure to the matrix as a filter:

    When the parameter is adjusted the values change:

    I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

    My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/