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
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.
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.
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?
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!
@@AccessAnalytic I thought parameters will solve the old method of switch a dynamic measure for using it with time intelligence filters but the expression didn’t work properly with parameters columns or the column copy.
Sadly this doesn't work if you want to show the values together, as can be seen in 4:38. It basically copies your first selected value to all the other enabled columns
I spent an hour looking for how to do this. You're brilliant.
Awesome! Glad I could help 😁
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
No worries. Thanks for taking the time to leave a kind comment
I love finding these golden nuggets. As several have already said: Concise, to the point and, more importantly, VERY useful!!! Thank you!
You’re very welcome
Thank you. It was concise and to the point explanation
You’re very welcome. I appreciate you taking the time to let me know you found it useful
Thank you, this solved the issue I was having, much easier than I expected!
Glad it helped
Great tip, hard to find elsewhere! Kudos!
I appreciate you taking the time to let me know you found it useful
You saved me a lot! Thank you very much
You're welcome
Thanks for the Preview Wyn!!! No doubt this will save many lines of code, powerBi is becoming more intuitive.
Thanks Jorge
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.
Interesting. Calculated columns don’t compress as well as Power Query loaded tables so maybe this is an example of that )
You just saved my day, thanks
You’re welcome 😀
Great video, thanks for the amazing tip!
Thanks, you're welcome
great sharing
Cheers
Very Useful🥳
Thank you
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.
Thanks for taking the time to let me know it was useful Neha :)
it' s wonderful thanks for sharing
You’re welcome Muhammet
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?
I don’t understand the example sorry
Thanks Wyn
You’re welcome Paul
thanks, great idea!
No problem!
great!
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!
For me the way it works is if nothing is selected it defaults to the first item in the slicer.
I'm facing the same issue. But I'm following exactly same but the issue is happening
@@arpitaghosh4468 the behaviour has changed and it now defaults to the first option in the list when no items are selected
Good job
Thankyou
4.42 If you don't use the filter the Sales and Units Sold values are the same (and they shouldn't be)
Oh yeah... that's odd. I'll ask around to see if that's expected behaviour
Can I use the new field parameter with TopN feature from filter pane?
Looks like you have to add the individual categories to the filter panel
Why do both measurements show the same values if you don't select any measurement?
That’s just the way they built it, you might be able to edit the formula to return a blank on no selection
Why its showing same amount in 2 bar after unselecting the filters.
I think it now defaults to that
Good! Searched for an hour myself 😞
Glad to help
Hi I’ve been trying to use a parameter into a Calculate without any success 😭.
What are you aiming to do?
@@AccessAnalytic I thought parameters will solve the old method of switch a dynamic measure for using it with time intelligence filters but the expression didn’t work properly with parameters columns or the column copy.
@@salecitam I'm not 100% following, but while measures can be dynamic (react to user selections), calculated tables and columns cannot
Sadly this doesn't work if you want to show the values together, as can be seen in 4:38. It basically copies your first selected value to all the other enabled columns
Can you give a bit more info. 4:38 still works for me?