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 all,
I have data that looks like this (below) and I want to create a slicer that contains all names in the headers (pcusers, nonpcusers,andriodusers, iOSusers) I found some examples but they are not working for me. any suggestions on the best approach to do this?
thanks!
date | pcusers | nonpcusers | androidusers | iOSusers |
11/15/2020 | 1% | 44% | 54% | 45% |
11/16/2020 | 3% | 33% | 45% | 54% |
11/17/2020 | 3% | 53% | 14% | 15% |
11/18/2020 | 6% | 53% | 15% | 23% |
11/19/2020 | 4% | 23% | 34% | 33% |
11/20/2020 | 9% | 22% | 53% | 90% |
11/21/2020 | 5% | 22% | 33% | 43% |
11/22/2020 | 3% | 12% | 45% | 60% |
Solved! Go to Solution.
Hi @FatBlackCat30 ,
Please check whether this could meet your requirements:
Best regards
Icey
If this post helps, then consider Accepting it as the solution to help other members find it faster.
Hi @FatBlackCat30 ,
Please check whether this could meet your requirements:
Best regards
Icey
If this post helps, then consider Accepting it as the solution to help other members find it faster.
thank you this is xactly what I was looking for
Hi,
No worry, unpivoting does not cuase any data loss. actually this process (Unpivoting) is required for all pivoted tables to use Power BI efficiently.
With Excel, we usually use(like) pivoted table, but power BI mostly uses unpivoted table.
Hence, if you will use Poer BI, I recommend to get familier with it.
Hope this helps. Thanks.
Hi,
First, you need to Unpivot the the table (except Date header) as below;
1. Home > Transform Data
2. Select the data table and unpivot all heards except Date
3. Close and apply and Create Slicer
Hope this helps you.
Hi @colacan Is this possible without unpivoting? Sorry I should have clarified that
Unpivot the data in power query. Click the date column, then "unpivot other columns". This will give you and attribute column and a value column. You can use attribute in your slicer
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 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |