Forum Discussion
filter aux table with date slicer
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(SU...
v-jiascu-msft
Microsoft Employee
Microsoft EmployeeHi 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.