Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hello,
I have a table with the column month numbers (which is connected/related with my main fact table) and two calculated columns YTD and FY. Now i want to creATE a slicer that has two options: Year to date (YTD) and Full year (FY). My problem is that the slicer options are from two columns and i dont know how to handle that. I have read an article form sqlbi "Creating a slicer that filters multiple columns in Power BI - SQLBI" but i didnt help me further.
help is much appreciated. Thank you 🙂
Thank you very much for your help @amitchandak
I tried to follow your suggestion but i dont really get your solution. Why sould i create a measure when you can't put a measure in a slicer?
With "Slicer[value]" in your measure do you refer to the column of the new table (with the two row values "Year to
date", "Full Year")?
@Anonymous , Have a new table with two row values "Year to date", "Full Year"
then have a measure like
measure =
var _filter =
Switch( selectedvalue(slicer[value])
"Year to date",filter(Table, not(isblank([Year to date])) )
"Full Year",filter(Table, not(isblank([Full Year])) )
)
return
calculate(sum(Table[Value]), _filter)
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
86 | |
85 | |
84 | |
67 | |
49 |
User | Count |
---|---|
131 | |
111 | |
97 | |
71 | |
67 |