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.
Hi All,
My Requirement is I have to show three dates in a column Table/Matrix by selecting three dates from slicer
If I select three dates the values get summarized and show in one column only
I have show like below in PowerBI,
country | Mar-21 | Jan-22 | Feb-22 |
A | 22 | 35 | 63 |
B | 25 | 67 | 45 |
Solved! Go to Solution.
Hi @Santho_BI ,
You can achieve this by placing the Category field above Date field in Columns section and then click on the below drill down option to show both levels in Matrix visual.
Hope this helps!
Please accept the solution if this answers your query.
Thanks,
Avantika!
Hi @Santho_BI ,
You can achieve this by placing the Category field above Date field in Columns section and then click on the below drill down option to show both levels in Matrix visual.
Hope this helps!
Please accept the solution if this answers your query.
Thanks,
Avantika!
Hi @Avantika-Thakur, If I put any category value under category it's work, if I put date it didn't work any other options.
Hi @Santho_BI ,
Few checks that you can do :
1) If all the dates are available in one single Date column, you can make its summarization as "Don't Summarise"
2) Now put the Date column in Matrix - Columns to view the selected dates
3) Please Note, if you are using the Table visual - it will show all the dates as rows in one single column and won't be able to separate out in separate columns. Hence its recommended to use a Matrix visual in this case.
Hope this helps!
Thanks,
Avantika
Hi @Avantika-Thakur thanks for the answers, in matrix it's worked one more point is the date will come under categories like below, I have to achieve like this
category 1 | category 2 | |||||
country | Mar-21 | Jan-22 | Feb-22 | Mar-21 | Jan-22 | Feb-22 |
A | 22 | 35 | 63 | 20 | 30 | 60 |
B | 25 | 67 | 45 | 22 | 65 | 43 |
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 |
---|---|
105 | |
105 | |
88 | |
73 | |
66 |
User | Count |
---|---|
124 | |
113 | |
98 | |
80 | |
72 |