Forum Discussion

alexa_0028's avatar
alexa_0028
Icon for Resolver II rankResolver II
5 years ago
Solved

Show table visual without some dimensions but with same result

Hi All, I am trying to achieve the result like below in my table visual , I want to keep the aggregation like below but show only  dimensions, is it possible in powerbi? Measure:  SUMX(SUMMARIZE...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    alexa_0028 
    You need either have a order line and sales measure in the visual. Or create a column for the Sales, only put category and sales column in the visual, choose "don't summarize" the sales column.

     

     

    Paul Zheng _ Community Support Team
    If this post helps, please Accept it as the solution to help the other members find it more quickly.

parry2k's avatar
parry2k
Icon for Super User rankSuper User
5 years ago

alexa_0028 or put category and sales in a table visual, and click arrow next to sales and click don't summarize.

 

✨ Follow us on LinkedIn

 

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡