Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
Anonymous
Not applicable

Create a table/matrix using columns from data model as rows based on a condition.

Create a table/matrix using columns from data model as rows and display corresponding values segregated as Total, Quarter 1, Quarter 2, etc.

For example, I have two columns in my dataset - IceCreams Sold, IceCreams Sold to children. I want my visual to show like this :

 

 TotalQ1Q2Q3Q4
IceCreams Sold     
IceCreams Sold to children     

 

Thank you in Advance!

1 ACCEPTED SOLUTION

Hi @Anonymous 

 

If you require the Quarter as the column per your post, then I suggest changing the Quarter from a measure to a calculated column or create a Date table (which would be more aligned to better practice).  You can use this link SQLBI Date Table.

 

Hope this helps 🙂

Theo

 

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias

View solution in original post

3 REPLIES 3
TheoC
Super User
Super User

Hi @Anonymous 

 

Click on Matrix visual.  Add the "Ice Creams Sold" and "IceCreams Sold to Children" in the "Values" section in the visual pane.  Then, add the "Quarter" column in the Columns section of the visual pane.  Go into the Visual's settings as per below and turn on the "Switch Values to Rows" button.

 

TheoC_0-1658870570473.png

Hope this helps.

Theo 🙂

 

 

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias

Anonymous
Not applicable

Hello @TheoC ,
Thank you for the response.

The Quarter is a measure created in the model. It's not getting added in the Column section of matrix.

Hi @Anonymous 

 

If you require the Quarter as the column per your post, then I suggest changing the Quarter from a measure to a calculated column or create a Date table (which would be more aligned to better practice).  You can use this link SQLBI Date Table.

 

Hope this helps 🙂

Theo

 

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.