Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
"My input source is an Excel sheet named 'Source-Reduced'. This sheet has been configured in Power BI. I am attempting to unpivot the following columns.
Total 2024 OB
Total 2023 RF9
Total 2023 RF6
TOTAL RF3 2023
OB23 Total 202
Before input, these columns show correct values as per the Excel sheet. After unpivoting, two columns are created: 'Attribute' and 'Value'. When I select a particular attribute column, the values appear significantly higher.
Before unpivoting, the total for the following columns is...
Total 2024 OB - 13,27,137
Total 2023 RF9 -14,39,790
Total 2023 RF6 - 14,55,355
TOTAL RF3 2023 -14,14,013
OB23 Total 2023 - 11,97,633
After above columns unpivoted only selected in power query i see large value instead of orginal values but before unpivot its showing correcet value .
Also attached power bi sample with before Pivot and after pivot sheet added with same input source. please find the Link Power bi Sample + Input File
Looking for support .. thanks in advane..
@bol i want 5 columns unpivot afther unpivot there will be only two columns one fore attribute and another for value .. so i want this 5 columns header want to use slicer in my report.
This is another question. I answered the first as "how to calculate the same amount".
As far as I understand, you have to create a measure for each of those 5 attributes for all your calculation.
Those 5 measures can be used as "columns" in a table visual (or other visuals).
You can also create a new table with your unique ID and adding those DAX formulas as new columns. That would give you 5 column headers.
As of using slicer, you have to be more specific as I don't get it.
Hello,
Here is a formula to calculate one of the sum you are looking for:
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
24 | |
17 | |
12 | |
12 | |
10 |
User | Count |
---|---|
32 | |
25 | |
16 | |
14 | |
13 |