How To Group Field Parameters in Power BI Using DAX - Enhance Report UI
8.2 هزار بار بازدید -
2 سال پیش
-
With the introduction of Field
With the introduction of Field Parameters in Power BI, report creators were given a tool to provide a better User Experience in reports.
But with great powers comes great responsibility...
In other words, if you add lots of fields to the Parameter Table in Power BI it will be difficult for report consumers to know which fields might be relevant for their analytical needs.
To solve this you, as a report author can enrich the auto-generated Field Parameter table in Power BI to allow grouping of the parameters.
And this is what I'm going to show you today!
Have a good one,
Roland
💪 New full-length videos coming every week 🤹♂
🤘 New short videos coming every week 👨🏫
📝 BLOG POST: https://bilingualanalytics.com.au/gro...
🎬 MORE VIDEOS:
Usage Metrics Report in Power BI - Know Your Report's Audience - Usage Metrics Report in Power BI - Kn...
Dynamic Row-level Security 🔐 - Based on Dimension Tables - Dynamic Row-level Security 🔐 - Based ...
Drop-down Page Navigation - When you have multiple report pages in Power BI - Drop-down Page Navigation - When you ...
Chapters:
00:00 Topic Of The Day - Group Field Parameters
00:30 Intro
00:42 BI-Lingual Analytics
01:02 Field Parameters
01:19 DAX Code + Data View For Field Parameters
01:44 Create A Table With DAX
02:45 Add A Column To The Parameter Table
03:05 Use The Column in DataViz
03:18 New Column Button
03:49 Wrap Up What We Learned
04:24 Question Of The Day
04:37 End
▼▼▼▼▼▼▼▼▼
Make sure to hit the 👍 button and ❗❗ SUBSCRIBE ❗❗ to my channel.
If you have any questions, just let me know either in the comments down below 👇 or send us an e-mail 📩.
▲▲▲▲▲▲▲▲▲
🤝 HOW TO CONNECT 🤝
LinkedIn - LinkedIn: bilingualanalytics
Twitter - Twitter: BILAnalytics
Subscribe - @bilingualanalytics
ABOUT ME: https://bilingualanalytics.com.au/abo...
📍 – Sydney, Australia
📽 GEAR:
📷 – Sony ZV-E10
🎙 – Audio Technica AT2020
🔦 – Neewer 18” Ring Light, Elgato Key Light
🎧 – BOSE QC35
🖥 – ASUS VC279H + Xiaomi Mi Curved 34"
💻 – AMD Ryzen 5900, NZXT N7, RTX 3060 Ti, Team T-Force ARGB 64GB RAM
Music: www.bensound.com
#PowerBI #FieldParameter #DynamicXaxis #BILingualAnalytics
But with great powers comes great responsibility...
In other words, if you add lots of fields to the Parameter Table in Power BI it will be difficult for report consumers to know which fields might be relevant for their analytical needs.
To solve this you, as a report author can enrich the auto-generated Field Parameter table in Power BI to allow grouping of the parameters.
And this is what I'm going to show you today!
Have a good one,
Roland
💪 New full-length videos coming every week 🤹♂
🤘 New short videos coming every week 👨🏫
📝 BLOG POST: https://bilingualanalytics.com.au/gro...
🎬 MORE VIDEOS:
Usage Metrics Report in Power BI - Know Your Report's Audience - Usage Metrics Report in Power BI - Kn...
Dynamic Row-level Security 🔐 - Based on Dimension Tables - Dynamic Row-level Security 🔐 - Based ...
Drop-down Page Navigation - When you have multiple report pages in Power BI - Drop-down Page Navigation - When you ...
Chapters:
00:00 Topic Of The Day - Group Field Parameters
00:30 Intro
00:42 BI-Lingual Analytics
01:02 Field Parameters
01:19 DAX Code + Data View For Field Parameters
01:44 Create A Table With DAX
02:45 Add A Column To The Parameter Table
03:05 Use The Column in DataViz
03:18 New Column Button
03:49 Wrap Up What We Learned
04:24 Question Of The Day
04:37 End
▼▼▼▼▼▼▼▼▼
Make sure to hit the 👍 button and ❗❗ SUBSCRIBE ❗❗ to my channel.
If you have any questions, just let me know either in the comments down below 👇 or send us an e-mail 📩.
▲▲▲▲▲▲▲▲▲
🤝 HOW TO CONNECT 🤝
LinkedIn - LinkedIn: bilingualanalytics
Twitter - Twitter: BILAnalytics
Subscribe - @bilingualanalytics
ABOUT ME: https://bilingualanalytics.com.au/abo...
📍 – Sydney, Australia
📽 GEAR:
📷 – Sony ZV-E10
🎙 – Audio Technica AT2020
🔦 – Neewer 18” Ring Light, Elgato Key Light
🎧 – BOSE QC35
🖥 – ASUS VC279H + Xiaomi Mi Curved 34"
💻 – AMD Ryzen 5900, NZXT N7, RTX 3060 Ti, Team T-Force ARGB 64GB RAM
Music: www.bensound.com
#PowerBI #FieldParameter #DynamicXaxis #BILingualAnalytics
2 سال پیش
در تاریخ 1401/03/23 منتشر شده
است.
8,299
بـار بازدید شده