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.
Hi,
I have set of data that I was able to add to Matrix table.
I am looking for accurate % per month and per Employee, that I can drill down for more detailed look.
I am able to get accurate % in Matrix but when I added Measure (I am looking for Reported HRS data to be shown in %)
The Measure is not working, and I am not able to locate the issue.
Any help would be appreciated.
Solved! Go to Solution.
Hi
MP Line Chart with % PBIX File
I shared PBIX file with Random Data.
I found a work-around to use 100% stacked Column chart and is showing proper % values and I would still like to have a LineChart as visualiazation of Billable Report.
On tabs Month and Quarter - I would like to have visible data that is in Matrix Table to be visible in LineCharts (at the moment I use 100% Stacked Column Chart)
Tab "Idel" - Data that is in Matrix Table (low right table) to be visible in Line chart (Left) with all Slicers that are connected to the Charts.
Thank you very much
Hi @mpesec
You might consider creating pbix file that will contain some sample data (remove the confidential info), upload the pbix to onedrive or dropbox and share the link to the file. Please do not forget to describe the expected results based on this sample data.
Hi
MP Line Chart with % PBIX File
I shared PBIX file with Random Data.
I found a work-around to use 100% stacked Column chart and is showing proper % values and I would still like to have a LineChart as visualiazation of Billable Report.
On tabs Month and Quarter - I would like to have visible data that is in Matrix Table to be visible in LineCharts (at the moment I use 100% Stacked Column Chart)
Tab "Idel" - Data that is in Matrix Table (low right table) to be visible in Line chart (Left) with all Slicers that are connected to the Charts.
Thank you very much
The part of problem is not clear, can you explain with example
In the Picture I attached is Example. File that I am working on, but because there are some personal information I am not able to share it with you.
The numbers on the right are the right numbers that should be visible on the LineChart.
But when I used Measure (noted in my previous message) is not working.
I somehow need Measure that would SUM up Reported HRS per employee and team with Month and Quarter.
Should I use 4 different Measures to be able to get accurate values?
* Reported HRs per Employee and Month
* Reported HRs per Employee and Quarter
* Reported HRs per Team and Month
* Reported HRs per Team and Quarter
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 | |
98 | |
78 | |
64 | |
56 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |