Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |