filmov
tv
Dimension & measure slicers in Power BI with field parameters
![preview_player](https://i.ytimg.com/vi/b1RH8nqnXf4/maxresdefault.jpg)
Показать описание
It's often useful to make a Power BI dashboard page that analyses various dimensions (e.g. gender, age, country, product, date) but where the user can pick which measure they want broken down by all of those, eg I want to switch between sales broken down by all those, into #customers for all of those into last months sales growth etc.
Or the other way around, various charts have multiple fixed measures and the user can select from a slicer the dimension. Field parameters can do both of these things, and here I explain them with some gotchas worth knowing.
00:00 Introduction
00:57 Measure slicer
03:36 New button slicer
04:13 More visuals from measure picker
04:51 Percentage issues
05:29 Add field/modify field parameter
06:40 Dimension picker
09:31 Chosen dimension without relationships
10:21 Numerical range parameter & Power Query
11:35 Field parameter options
13:16 Show dimension elements in slicer based
Or the other way around, various charts have multiple fixed measures and the user can select from a slicer the dimension. Field parameters can do both of these things, and here I explain them with some gotchas worth knowing.
00:00 Introduction
00:57 Measure slicer
03:36 New button slicer
04:13 More visuals from measure picker
04:51 Percentage issues
05:29 Add field/modify field parameter
06:40 Dimension picker
09:31 Chosen dimension without relationships
10:21 Numerical range parameter & Power Query
11:35 Field parameter options
13:16 Show dimension elements in slicer based
Dimension & measure slicers in Power BI with field parameters
Power BI - Filter by a Measure in a Slicer
Change Measure using a Slicer
Slicing by Measure Categories in Power BI
Select measures dynamically from a slicer in Power BI | Dynamic Measures | DAX Sundays |Power BI |4K
Going CRAZY with Power BI slicers not filtering other slicers????
Display columns dynamically using a Slicer in PowerBI | Tutorial | MiTutorials
How to FILTER OTHER SLICERS without using BI-DIRECTIONAL cross filter in POWER BI| CASCADING SLICERS
Build a Slicer Panel in Power BI (2022/2023)
Filters based on content of other tables in Power BI - Unplugged #44
NEW! Dynamic Slicers with Fields Parameters | ULTIMATE EXAMPLE in Power BI
A TWIST on dynamically filtering visuals by a slicer in Power BI
SMARTER Slicers = BETTER User Experience | Show Only What's Relevant in Your Slicers in Power B...
Power BI - Directly Compare Two Categories (Slicer Filters Other Slicer)
Sync two different slicers from different tables without a relationship in Power BI
Power BI Dynamic Measures: Switch Between Measures Using Slicers
Change measures using slicers in Power BI Desktop- Power BI Tips & Tricks #20
NEW Button Slicers in Power BI | 3 Examples You Don’t Want to Miss!
DAX Fridays! #118: Get selected or multiple values from slicers using DAX
10 Secret 3D Printing Tricks Only Experts Know...
Filters vs Slicers in Power BI Tutorial (39/50)
Using the SELECTEDVALUE function in DAX
Power BI - Dynamic Axis via Slicer (No DAX)
Dynamic X and Y Axis in Power BI visuals? Yes please!
Комментарии