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 .
@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
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?
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.
We are excited to announce the Power BI Super Users!
Overview of Power BI 2020 release wave 2!
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.