Visual in the Report

[a_rp]

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 right side. Please guide me and also suggest any graphic visuals. I want to use both table/matrix type visual (shown on right in the pic) as well as graphic one.

[amitchandak · Accepted solution]

@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

[a_rp]

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)?

[a_rp]

Hi @amitchandak I got it! It's working...thanks again. Any suggestions for showing this matrix in graphical way?