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.
Hello everyone,
Is it possible to filter columns in the matrix separately by its own slicer? I have a bunch of indicators in the row for different people. I want to compare their performance by two different date range according to my wish. Right now I have two separate tables for that, but I'd like to have it in one. Is there a way to do that? Matrix doesn't allow me to add another column to 'columns' tab
Highly appreciate any solution. Attached are the pbix and the image of what I'd like to achieve
Solved! Go to Solution.
Hi @powerbiuser444 ,
see if you can follow the logic of the attached PBIX file.
I have added a KPI table to build a star schema bit by bit.
Also your date tables should contain unique values and thus have a 1:* relationship.
The measure decides how it is calculated depending on the KPI displayed.
@mwegener hello, could you please help to solve the next issue I encountered? After data transformation and unpivoting columns I added another ratio measure (SPH), but because you used 'calculate(sum...' in the formula it sums up the numbers for higher hierarchy (the logic should be the division of talk time by sales for the department, not the sum of agents in that department). How that can be fixed? Appreciate you help!
I'm attaching the link Link to pbix
Hi @powerbiuser444 ,
see if you can follow the logic of the attached PBIX file.
I have added a KPI table to build a star schema bit by bit.
Also your date tables should contain unique values and thus have a 1:* relationship.
The measure decides how it is calculated depending on the KPI displayed.
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |