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 All,
I have a strange issue here. I have imported an Excel sheet and performed "Unpivot Select Columns" on few columns. Once unpivoted, I tried to filter the rows on the "Attribute" column (which will have the list of column headers before unpivot) by some value. The drop-down of that filter is showing the value( shown in pic 1), but when I apply filter based on that value, no rows are being returned(shown in pic 2). It's showing "This table is Empty" message. Can someone please help here?
Hi @AnushaAv
Hi @AnushaAv
As tested on my side with last version,
It works to filter the column after unpivot selected columns.
Please check the version and update to the lastest one,
share some example data or code in Advanced editor so i can make a test.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Is that the only filter you have applied and is what you show the last step in your query?
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.