Forum Discussion
Adding two Slicers ?
So I had help from here yesterday, Calculating a % between two numbers in two queries which was a great help.
My next , and hopfully my final problem is creating a slicer for the month so the user can chose.
I have three queries, I have one slicer already for chosing the customer, I have created a relationship between the customer column on each query as below.
So now I want to be able to filter on month also, but within the relationship I can only chose one column ?
Each query has the column Customer and Column Date - How would i go about being able to select both a customer and a month?
As always any help greatly appriciated
Ben
Hi Benc7777 ,
If you haven't already, create a separate Date table that contains a unique list of months (and possibly other date parts like year, quarter, etc., depending on your needs).
Date = CALENDAR (date(2023,1,1),date(2024,12,31))Then put the date column into the slicer.
Finally create a measure.
measure=var _1=selectedvalue('date'[date]) return if(max(query[date])=_1,1,blank())How to Get Your Question Answered Quickly - Microsoft Fabric Community
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi Benc7777 ,
If you haven't already, create a separate Date table that contains a unique list of months (and possibly other date parts like year, quarter, etc., depending on your needs).
Date = CALENDAR (date(2023,1,1),date(2024,12,31))Then put the date column into the slicer.
Finally create a measure.
measure=var _1=selectedvalue('date'[date]) return if(max(query[date])=_1,1,blank())How to Get Your Question Answered Quickly - Microsoft Fabric Community
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.