Below is the format that I currenly have. I would like to pivot the table where the Months display as columns and Budget numbers as rows. All the tables are in SSAS bim file so I need this accomplished through DAX.
** Note: Besides the Month colum, all other colums are Measures.
Hi @Anonymous,
Put you months names on the columns and then on the optios go to:
- Values:
- Show on Rows - On
This will place the measures on the rows and not on columns.
Regards,
MFelix
Regards
Miguel Félix
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
Check out my blog: Power BI em Português
Hi @Anonymous,
Put you months names on the columns and then on the optios go to:
- Values:
- Show on Rows - On
This will place the measures on the rows and not on columns.
Regards,
MFelix
Regards
Miguel Félix
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHelpful resources
Power BI Dataviz World Championships
Vote for your favorite vizzies from the Power BI World Championship submissions!
Join our Community Sticker Challenge 2026
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Power BI Monthly Update - January 2026
Check out the January 2026 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
| User | Count |
|---|---|
| 56 | |
| 52 | |
| 45 | |
| 17 | |
| 16 |
