Forum Discussion
Merging two visuals
I have two visuals (see attached pbix), the top visual shows the number of videos viewed per month by type (live or ondemand), the bottom visual shows the number of total videos uploaded per month:
I would like to combine these into one visul like:
rsp385 you did everything right, except putting month on columns, you added it on rows, see attached.
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.⚡
4 Replies
rsp385 you did everything right, except putting month on columns, you added it on rows, see attached.
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.⚡
Thank you very much.
rsp385 I looked at pbix file and you need to update your model. First you need to add dimension in your model that will have relationship with these two tables, one to many, date on one side.
- create measure on these two queries, one for live , on demand and uploaded.
- add a matrix visual
- put month column from date dimension on columns
- add your 3 measure on values
on format pane, turn on the setting called "show on rows" and that will get you the expected result.
For date dimension, you can check my post here.
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.⚡
