Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Prabha45
Helper III
Helper III

Selectedvalue blank

Hi All,
I got stuck with the selected value DAX. Its returns blank like the below image. What am I missing.
Please help me. I know this looks silly but I don't understand the error.
TIA

Pic.jpg

1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

Hi @Prabha45 
The formula returns blank because you are using date hierarchy in your slicer. 

So you didn't select a date, you selected the year and month.

Modify your measure according to the possible selections, for example :

slected year_month = SELECTEDVALUE('Dates'[Date_].[Year])&"-"&SELECTEDVALUE('Dates'[Date_].[Month])
( you can add a quarter and day if you need them too)
result :
Ritaf1983_1-1701449990549.png

 

 

PBIX is attached

If this post helps, then please consider Accepting it as the solution to help the other

members find it more quickly

 

 

View solution in original post

5 REPLIES 5
Prabha45
Helper III
Helper III

Thanks @Ritaf1983 
It worked, I'm trying to show value PLAN if month greater 2023 June based on the date hierarchy.
Measure = 
Var selectyear = Selectedvalue(dim_date[date].[Year])
Var selectmonth = Selectedvalue(dim_date[date].[month])
Var ans = If(selectyear =2023 & selectmonth > "June",
                     [PLAN],
                     [ACTUAL])
The above measure throws an error. Doesn't support comparing values of type integer with values type text.
Please help on this

Hi @Prabha45 
1. You can't use the operator "<>" to compare strings, and month in this case is a string.
2. if you nee and as an operator you should use "&&" and not "&"
modify your formula to :

Measure =
Var selectyear = Selectedvalue(Dates[Date_].[Year])
Var selectmonth = Selectedvalue(Dates[Date_].[month])
Var ans = If(selectyear =2023 && selectmonth in {"july","August","September","October","November","December"},
                   
                   [plan],[actual])
                     return ans
Ritaf1983_0-1701532843951.png

The updated pbix is attached. 
(i used just strings for plan and actual )

If this post helps, then please consider Accepting it as the solution to help the other

members find it more quickly

Thank you @Ritaf1983 
Can we do it in reverse. Show data [Actual] if selected date less than 2023 June. Going forward data gets updated for 2024,2025....
My data starts from 2020.

 
Var ans = If(selectyear =2023 && selectmonth in {"January","February","March","April","May","June"} &&  If( selectyear = 2022 && selectmonth in {"January" ............"December"}
&&  If(selectyear = 2021   && selectmonth in  {"January" ............"December"}
&& If(selectyear = 2020 && selectmonth {"January" ............"December"}
 
                   [actual],[Plan])
                     return ans

Is this the only way ?

Hi @Prabha45 
I recommend just to work with a "Date" type slicer ...

Ritaf1983_0-1701535458531.png

working with hierarchies here seems to me too many "woodo dances" for the very simple scenario 

If this post helps, then please consider Accepting it as the solution to help the other

members find it more quickly

Ritaf1983
Super User
Super User

Hi @Prabha45 
The formula returns blank because you are using date hierarchy in your slicer. 

So you didn't select a date, you selected the year and month.

Modify your measure according to the possible selections, for example :

slected year_month = SELECTEDVALUE('Dates'[Date_].[Year])&"-"&SELECTEDVALUE('Dates'[Date_].[Month])
( you can add a quarter and day if you need them too)
result :
Ritaf1983_1-1701449990549.png

 

 

PBIX is attached

If this post helps, then please consider Accepting it as the solution to help the other

members find it more quickly

 

 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.