Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I need to have in the same matrix two colums from the same table and one of them with a date slicer and the other with a different date slicer, and the user can choose any day in both
Solved! Go to Solution.
I have duplicated the date column in two new tables, date1 and date2, and I have removed duplicated on colum dates in both tables. I have also used date1 and date 2 as slicers and duplicated the dax calculates within each date table.
thank you to help me
If you are trying to filter if one of the columns has a date? You could duplicate the tables with a new date field where first table has the first date and the second table has the second date and then slice based on that column.
I have duplicated the date column in two new tables, date1 and date2, and I have removed duplicated on colum dates in both tables. I have also used date1 and date 2 as slicers and duplicated the dax calculates within each date table.
thank you to help me
Hi @Anonymous,
Slicer is used to filter the row of a table, you want to control two columns based two different slicers, which is unsuppported up to date. Please review the ideas below and vote them.
Multi-Columns Slicer
AND Slicer - OR Slicer - Measure Slicer
Slicer base on column base on slicer
Best Regards,
Angelia
Thank you Angelia
I can do it, I have duplicated the table and I use the date from each table as slicer
but I can´t operate between the columns.
Please share some sample and list expected result.
thanks for attended my enquire, we all ready got it done
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |