Forum Discussion
Unpivoting in Frontend
Hi all,
I have Good, under, Over ,assemblies, Materials, Production columns in my pbi
In these columns True, Blank values are there
I want these good, bad, under and all to be shown in status and count of True values for each status
For example if i select 215 from Top_code slicer the chart must show count of true for each status, like this it must give count of true for whatever Column filter I give
I used below, but it giving correct count only for top parent, but not for all
Please help
2 Replies
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Hi Anonymous ,
Based on my understanding, you created a calculated table, right?
But it's important to know that the calculated table is a static result, and it can't return a result dynamically based on the slicer's choice.
Well, to help you more effectively, I would suggest using the Power Query Editor to unpivot your columns, which will transform your data into a more suitable format for the analysis you're trying to perform. Here's how you can do it:
Unpivot columns - Power Query | Microsoft Learn
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
