Adding two Slicers ?

[Benc7777]

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

[v-rongtiep-msft]

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 _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.