cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper III
Helper III

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

chandru123_0-1601458615081.png

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 . 

chandru123_1-1601458738894.png

Please do the needful as soon as possible.

thank you in advance . 

 

6 REPLIES 6
Super User IV
Super User IV

@chandru123 , 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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Hi I didnt get the answer , 

I need group by for Month wise not values wise 

chandru123_0-1601461269316.png

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 .

Hi @chandru123 ,

 

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

 

Capture3.PNG

 

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

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

@chandru123 , 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.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors