Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi Everyone,
This should be my end output:
But the Problem is My data is coming out of 100% and Above Output is showing DATA according to Total Hours for that month.
I hope I'm able to describe my problem statement.
Current Table :
Output Table :
I want to achieve like this so that I can create the graph as shown above.
You can ignore the Month Column of Output table as I'm okay with using Month Name & Month Number column as it is.
I hope my problem is clear.
I have used this following script in Warehouse to create the table :
CREATE view dbo.vwGetData
As
WITH cte as
(
SELECT
Month_Name,
Month_Number,
Project_Category,
100.0 * Actual_Hours / NULLIF(SUM(Actual_Hours) OVER (PARTITION BY Month_Name, Month_Number), 0) AS Percentage
FROM
[dbo].[TimelogByType]
)
select cte.Month_Name,
cte.Month_Number,
cte.Project_Category,Sum(cte.Percentage) AS Percentage from cte GROUP by cte.Month_Name,cte.Month_Number,cte.Project_Category;
Can anyone help me out in this to get the desired output?
Solved! Go to Solution.
Hi @lovishsood1
1) Pivot the Category Column, and Select the Actual_Hrs as the Values
2) Add a Total Column
3) Add Custom Columns to calculate the shares
Please find here the solution PBIx, check the Power Query for the solution.
Hi @lovishsood1
1) Pivot the Category Column, and Select the Actual_Hrs as the Values
2) Add a Total Column
3) Add Custom Columns to calculate the shares
Please find here the solution PBIx, check the Power Query for the solution.
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.