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.
Hi,
I am trying to add a trend line to a bar chart. The x-axis is Months (Jan, Feb, Mar etc.). And I know can add a trend line to a column if it a number (not text). I came across the following Cubes (SSAS) Date Filters and PowerBI Post which was very helpful but I do not know where to go in order to change the properties of the date attributes. Any help would be much appreciated .
I do not know how to get here .
Thanks
Hi @soniamtw,
>>but I do not know where to go in order to change the properties of the date attributes.
If you mean sort by month, you can add key/value properties about 'year month', then use year month as sorting order.
Reference links:
Sorting month by natural sort order
Regards,
Xiaoxin Sheng
Hi Xiaoxin,
I am trying to add a trend line to a bar chart. But since the x-axis is Months (APR, MAY, JUN etc..) and it is in text format it will not let me add a trend line. I found on one of the post that if you change the properties of the date attribute then it will work. But I am not sure how to get to the properties sections. (Cubes (SSAS) Date Filters and PowerBI Post)
Thanks.
Hi @soniamtw,
Actually, I think it means setting column as key/value, use name properties to display name(text) and sort with stored value properties(key).
In addition, you can also post to SSAS related forum to know more about operate SSAS cube data model.
Regards,
Xiaoxin Sheng
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 |