Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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:
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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
81 | |
75 | |
60 | |
37 | |
33 |
User | Count |
---|---|
102 | |
56 | |
52 | |
45 | |
40 |