Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have a parameter for users to select the quarter of the year so the list should be 1 to 4.
When I run the parameter query there is a null (see screenshot). I think it's causing issues for other paramaters, is there a way to remove this null?
Solved! Go to Solution.
Method 1:
EVALUATE
FILTER(
SUMMARIZECOLUMNS(
'Calendar'[Quarter]
), 'Calendar'[Quarter] <> Blank())
Method 2
EVALUATE
FILTER(
DISTINCT(
'Calendar'[Quarter]
), 'Calendar'[Quarter] <> Blank())
Method 3
EVALUATE
FILTER(
DISTINCT(
'Calendar'[Quarter]
), 'Calendar'[Quarter] <> Blank())
Proud to be a Super User!
This also helped me with select all as a default value. I was strugling with it for so long.
Method 1:
EVALUATE
FILTER(
SUMMARIZECOLUMNS(
'Calendar'[Quarter]
), 'Calendar'[Quarter] <> Blank())
Method 2
EVALUATE
FILTER(
DISTINCT(
'Calendar'[Quarter]
), 'Calendar'[Quarter] <> Blank())
Method 3
EVALUATE
FILTER(
DISTINCT(
'Calendar'[Quarter]
), 'Calendar'[Quarter] <> Blank())
Proud to be a Super User!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
84 | |
66 | |
62 | |
62 |
User | Count |
---|---|
199 | |
120 | |
110 | |
79 | |
69 |