Forum Discussion
Solved
Visual in the Report
Dear All, I have MS Access Database where I have created a query that generates a table as shown in below pic. I have connected my Access Database to Power BI and I want a visual as shown on the rig...
a_rp , You need to have measures for revenue, profit, Manpower, etc on values in Matrix Visual
Profile and Project on row and date on column
Enable Show on row
amitchandak
Super User
Super Usera_rp , You need to have measures for revenue, profit, Manpower, etc on values in Matrix Visual
Profile and Project on row and date on column
Enable Show on row
Thank you Amit amitchandak for quick help! Do you mean to create (dummy) measures even though I have their values in my query result? Can you plz give an example for one measure (the formula)?
Hi amitchandak I got it! It's working...thanks again. Any suggestions for showing this matrix in graphical way?