Field Parameters and Calculation Groups-Single click to update both columns and measures in Power BI
HTML-код
- Опубликовано: 8 сен 2024
- #POWERBI #MICROSOFT #MICROSOFTPOWERBI #DAX #MICROSOFTPOWERBIDATAANALYSIS, #DATAANALYSIS, #BUSINESSINTELLIGENCE #BI #PERYTUS #DECIPHERYOURDATA #DAX #DYNAMICMEASURE #FIELDPARAMETERS #CALCULATIONGROUPS #DYNAMICCOLUMNS
Field parameters and Calculation Groups are very powerful methods in Power BI that allows us to dynamically select measures and columns.
In this video, for the first time we will explore how with a single selection we can change both columns and measures to personalize the visuals. It will help to develop user-friendly reports (fewer clicks) and easy-to-scale solutions.
Some of the important links for reference: 👇
👉 How to use selected value with field parameters tinyurl.com/2p...
👉Field Parameters vs Calculation Groups tinyurl.com/3u...
👉Top 3 use cases of field parameters tinyurl.com/46...
Enjoy!!
🌏: perytus.com/
✍: perytus.com/blog/
📞: perytus.com/co...
Your creative and out of the box thinking is greatly appreciated. Great material. Thank you!
Glad you liked it! Thanks for your feedback. Best regards!
Great job!! So resourceful, and shows that Calculation Groups and Field Parameters can be used together which was something I was really unsure about. Thank you!
Glad it was helpful! Thanks for the feedback. Much appreciated 🙏
Wow , very creative ..
Thank you! Cheers!
This is just pure magic
Thanks a lot! Much appreciated.
Thank you so much. I am going to try this principle as I have a similar issue where I want to be to show daily or monthly info for a number of visuals and I want to use calculation groups and field parameters. Would have been good if you also showed the model relationships in relation to the field parameters. I will try your solution. Hope this works.
Glad it was helpful! Please share your findings and let me know if you run into any issue. Good luck!
Yes it worked. Am now able to switch between daily data and monthly data. Also combined it with previous dates video from sqlbi to be able to see the last six months using a single slicer selection. Great stuff.
@@damionc 👏Thanks for the feedback and glad to hear that it worked for you. This is exciting. Thanks and promote the channel (if possible) so that others can learn/use/take advantage from it. 🙏
I assume you use MAXX instead of selectedvalue because the field parameter is a tuple and selected value can't return the Period. Is that correct ? br
Thanks for the question. Yes, I could have used _SELECTEDVALUE_ dax function as well.
How to access selected measure value in calculated column
Hi Muhammed, Can you explain what you are trying to achieve? It is not easy to answer without having more detail. Thanks!