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.
Hi
I am trying to use a numeric range parameter to create a new column. I've been pulling my hair out because it looks like PowerBI is just reading the parameters as blank. See below the first screenshot where all I try to do is make the column equal to one of the parameters. I can't for the life of me figure out why the column is blank?! Second screenshot shows the report where I have the parameters.
Some more details. I have three parameters, ShiftYear, ShiftMonth and ShiftDay. My hope had been to combine these parameters together and compare to the start and end dates in my data to calculate some metrics of interest. These metrics change depending on what day you're looking at so I figured a new column that changes dynamically based on user input would be the way to go rather than having a new column for every possible day.
Not sure if this will help anyone help me. I just tried doing it slightly differently. I made a measure that is absolutely definitely the datetime that I want and set the new column equal to that date. The datetime in the new column is 0 but it keeps any times I add on. So it's definitely reading the measure but just doing something super strange?!?!?
Hi @ICTJZT ,
Here's why you're seeing blank:
Proud to be a Super User!
Hi mate
I've tried refreshing the data and using SELECTEDVALUE multiple times but am still having the same issue.
What do you mean when you say there are multiple values? Each parameter only has one value.
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 |
---|---|
85 | |
83 | |
66 | |
60 | |
57 |
User | Count |
---|---|
188 | |
111 | |
105 | |
78 | |
71 |