Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I have a slicer date filter in my report.
I have also a tipical table called Reading with columns: name, date and amount.
I created an auxiliary table as follow:
Capa = ADDCOLUMNS(SUMMARIZE('Reading','Reading'[Name],"Average of Amount",AVERAGE('Reading'[Amount])),"Ranges",SWITCH(TRUE(),[Average of Amount]>1.5,"Critical","Other"))
The problem is that the auxiliary table doesnt considere the page date slicer filter. How can I do to Capa table consideres tha date slicer filter of the page?
Hi @Anonymous,
Do you mean the auxiliary table is a calculated table? If so, the slicer can't filter it directly. You need to create a visual based on the auxiliary table.
Best Regards!
Dale
yes, the auxiliary table called "capa" is a calculate table with columns, Name, Average of Amount and Description. The description is a switch that decides depend the result on Average Of Amount.
I did not understand well your asnwer, in the calculate table I dont have the date, should I add the date in the calcuate table? If I added it the average is not calculated well as the avg will be calculated per day and name and I want just the avg per name but filter by all dates in the date slicer.
Hi @Anonymous,
The point is the slicer can't filter the calculated table directly even the calculated table has a date column. Can you try to use the formula in a measure? What do you want in a visual exactly? Maybe you can share a sample.
Best Regards!
Dale
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |