Forum Discussion
How to show evolution during time?
Does anyone know how i can show data divided in months in the last 3 years? It only lets me show either the total by year, or the total by month, but i want the information to disaggregate the information.
thanks
Hi dberrocal,
>> It only lets me show either the total by year, or the total by month, but i want the information to disaggregate the information.
Based to your description, you want to divided the month and year data like below ?If it is a case, you can use matrix to achieve your requirement.
Create the matrix visual, drag date to “Rows” field, drag the amount to “Values” field.Remove the quarter and day.
You can also use ankitpatira’s point of view, add the year/month column, drag the year/month column and value column to table visual:
Regards,
Xiaoxin Sheng
2 Replies
dberrocal You can do that in power bi desktop by splitting out date field in your dataset using DAX. So create calculated column that gives you value in 'JAN-15' format for each row of date you have in your dataset and then use that column for category (x-axis) in your visual.
= 'TABLENAME'[COLUMNNAME].[Month] & "-" & YEAR('TABLENAME'[COLUMNNAME])
Hi dberrocal,
>> It only lets me show either the total by year, or the total by month, but i want the information to disaggregate the information.
Based to your description, you want to divided the month and year data like below ?If it is a case, you can use matrix to achieve your requirement.
Create the matrix visual, drag date to “Rows” field, drag the amount to “Values” field.Remove the quarter and day.
You can also use ankitpatira’s point of view, add the year/month column, drag the year/month column and value column to table visual:
Regards,
Xiaoxin Sheng
