Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
100 | |
87 | |
81 | |
76 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |