Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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
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
@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])
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |