To show three dates in column

[Santho_BI]

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

[Avantika-Thakur · Accepted 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!

[Santho_BI]

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.

[Avantika-Thakur]

@Santho_BI  - Can you show how you are using the fields in columns?

[Santho_BI]

[Avantika-Thakur]

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

[Santho_BI]

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