date converted into MMYYYY format but I am getting the values as DDMMYYYY format records

[Anonymous]

Hi  I have converted the date format to MMYYYY format in above image  . And i have used the same in table visualisation with Dont Summarise option. The output i need is as below but i am getting as above image . 

Please do the needful as soon as possible.

thank you in advance . 

[amitchandak]

@Anonymous , Same values will always group or summarize in all visuals

In case you need all values. add index column and add that in visual

https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi

[Anonymous]

Hi I didnt get the answer , 

I need group by for Month wise not values wise 

[Anonymous]

Hi @amitchandak ,

In the above image , If we see the 2nd visual , I have selected Decmeber 2014 but it is reflecting as 1st December 2014 which is wrong for my analysis .

[v-deddai1-msft]

Hi @Anonymous ,

Have change the Aggregation type of the Budget Hours , Actual Hours and Hours Utilized% to sum?

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[MCornish]

Changing the format of the column doesn't change the data. So underneath it still thinks ists showing days. You need to add a new column that formats the date.

Then when you aggregate it will be at the month level

[amitchandak]

@Anonymous , Can you check Aggregation is Budget and Hours also. Seem like one of them is either text or aggregation is not summarize.

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.