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.
Good morning,
I am trying to create a table similar to picture 1 in which the months are in the columns. However, in the new model, I have a fact table as a calendar and the months are in rows (picture 2), and I would like to have them in the column, any idea how I can do it with a table rather than a matrix?
Thank you in advance
Picture 2 Picture 1
Hi @miriambb,
A Matrix is going to be the easier way, is there a reason you're not wanting to use one?
To get that in a table you'd need to create a measure for each month and add them all in to the table. However, you wouldn't be able to dynamically filter the columns (such as by year) and you'd have to add a new measure for each new month.
Hi Antonio!
Thank you for your help!
I actually managed to do it with a table and flat the hierarchy and now as a Matrix
Thank you for your helo!
Miriam
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 | |
99 | |
75 | |
63 | |
62 |
User | Count |
---|---|
143 | |
104 | |
103 | |
82 | |
66 |