Fields Parameter - how to make SELECTEDVALUE work and how to change colours for different measures

🔽More Information below🔽
A couple of tips when working with the new Field Parameter

Fields Parameter - how to make SELECTEDVALUE work and how to change colours for different measures

02:10 - How to change the color of selected parameter
04:51 How to get SELECTEDVALUE to display the selected item in the heading of a chart

Dummy Data sets can be found here

You can download the PBI Desktop file I used here

Previous video on this topic

Connect with me

[sholder]

I spent an hour looking for how to do this. You're brilliant.

[rauljimenez]

I love finding these golden nuggets. As several have already said: Concise, to the point and, more importantly, VERY useful!!! Thank you!

[lexlohm]

After hours of searching the internet, you're video made SO much sense in explaining what Parameters do on a basic level. It really has helped my understanding of the feature and allowed me to troubleshoot my work to a functioning state. thank you and cheers xx

[abduyassin]

Thank you. It was concise and to the point explanation

[FredMartins-ng]

Great tip, hard to find elsewhere! Kudos!

[bradleybarker]

Thank you, this solved the issue I was having, much easier than I expected!

[jorstube]

Thanks for the Preview Wyn!!! No doubt this will save many lines of code, powerBi is becoming more intuitive.

[talytarosas]

You saved me a lot! Thank you very much

[nehasaini]

Thanks a bunch for the video. I used your technique to figure a workaround for displaying multiple selected values from a parameter slicer using concatenation. Ughhh!!! there is no explicit way to get to it and I kept searching until I watched this video.

[benlewellyn]

Thanks, Wyn! Have you noticed that the 'Chosen Measure'[Measure Name] takes up a ton of space? I've used this technique across 5-10 fields parameter sets and when I run Bravo against it each of these columns shows up as 1.02 MB despite being ~15 rows on average.

[garrettfox]

Great video, thanks for the amazing tip!

[muhammetmuslu]

it' s wonderful thanks for sharing

[IvanCortinas_ES]

4.42 If you don't use the filter the Sales and Units Sold values are the same (and they shouldn't be)

[archkz]

Hi! Do you think it it's possible to pass additional calculation based on selected parameter? For example, if I use parameter to slice bar chart by different categories (let's say first by region and then by country), when I slice by region I want to show all regions, but when I slice by country I want to filter out specific countries so they are not shown on the chart?

[sauliuspreidys]

Why do both measurements show the same values if you don't select any measurement?

[samnad]

Why its showing same amount in 2 bar after unselecting the filters.

[MrMiguelo]

My problem is that I do it exactly as shown in the video, I select an option in the slicer and the graph changes, when I deselect that value from the slicer (or clear values selected), the graph info does not change to "clear values". The last selected option remains and not the "general view". But, when you select nothing on the slicer, it does go back to show the graph general view. Any thoughts? THANKS!

[FANABRA]

Can I use the new field parameter with TopN feature from filter pane?

[salecitam]

Hi I’ve been trying to use a parameter into a Calculate without any success 😭.