Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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 , 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?