Repeated date filed to merge together

[Anonymous]

Hi,there,

I want to merge the same filed together in Power BI, what can i do ? Please help me,thanks.

Dora. 

[PhilipTreacy · Accepted solution]

Hi @Anonymous 

Download example PBIX file

You could try using a Matrix visual, like this.  It's not exactly the same as the layout in Excel but it's the closest you'll get.

With Year, Month and the Index number in the rows.  But I don't know how you expect the data to be displayed - the values that you have colored red, green and yellow in your first image.

In the example PBIX file I've provided, I've had to make up some data so it might not (probably won't) match yours.  So the way you have to set up the Matrix is likely to be different.  But without your actual data I have to guess at your data structure.

Regards

Phil

[PhilipTreacy]

Hi @Anonymous 

The picture doesn't show anything merged, it shows 5 Septembers, 4 Octobers, etc.

Your 2nd column appears to be some sort of Index,  Numbers are in sequence: 31, 32 etc.  Because this column is being displayed, the dates will not 'merge'.  Try removing this column.

But if this column is required then I still need to know how you want the values in the other columns merged.

What are ther values in these other columns?

Please provide your PBIX file.  It's really hard to answer your question without access to your file.

Regards

Phil

[Anonymous]

@PhilipTreacy  Thanks you for answer me patiently. Maybe i convey wrong meaning i's sorry.

This picture is done in excel , and i want this format show in power BI, so what can i do ?

Thanks a lot~

Dora.

[PhilipTreacy]

Hi @Anonymous 

Need some details on exactly how you want things merged.  What are the other values in the table?  How do they get merged/affected/displayed if months are merged? 

Please supply some sample data and expected results showing how the values in the table will look after merging months.

Regards

Phil

[Anonymous]

@PhilipTreacy ,I mean in the date column there are many repeated years amd months, i want to merge them into one like the picture show. they are five september and i want to show in one september ,thanks.