Forum Discussion
Matrix visual: several categories (rows) and values by time (columns)
Dear community,
I try to create a matrix-visual that shows several category-values in a time line. For example Revenue, Pipeline, EBITDA in rows and January, February, March etc. in columns.
The problem is, when I put the time (month) in columns, the categories in rows and the values (Revenue, EBITDA/ Pipeline) in values, the visual splits the time-columns, which means that the values are not among themselves in one column, rather in 3 columns.
Does anybody has an idea to solve the problem?
Thanks,
Katja
Anonymous not exactly sure what you are looking and what you want. But try this, on format pane, turn on "show on rows", if that is not what you are looking for the share some screenshots and provide more details on expected output.
Check my latest blog post Compare Budgeted Scenarios vs. Actuals 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.⚡
1 Reply
- parry2k
Super User
Anonymous not exactly sure what you are looking and what you want. But try this, on format pane, turn on "show on rows", if that is not what you are looking for the share some screenshots and provide more details on expected output.
Check my latest blog post Compare Budgeted Scenarios vs. Actuals 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.⚡