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.
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
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |