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.
Guys,
I have a dataset like this:
Customer ID | onsite/offshore | Region | 01-01-2011 | 01-02-2011 | 01-03-2011 | 01-04-2011 |
Customer1 | onsite | Kuwait | 200000 | 200000 | 200000 | 300000 |
Customer2 | offshore | UK | 200000 | 200000 | 200000 | 300000 |
Customer3 | onsite | USA | 210000 | 210000 | 210000 | 210000 |
Customer4 | offshore | USA | 220000 | 220000 | 220000 | 220000 |
Customer5 | offshore | USA | 210000 | 210000 | 210000 | 230000 |
Customer6 | offshore | Denmark | 220000 | 220000 | 220000 | 240000 |
Customer7 | onsite | Australia | 230000 | 230000 | 230000 | 250000 |
I want to create a chart for the data, with time filter (viz., the column name).
Problems I face are:
1. When I load this data into Power BI, it will not load date as a column name!! Instead it gives default column names (Column4, Column5, Column6, etc). How to load date as column name??
2. Assuming I can upload data with dates as column names, I make a duplicate of the table. If I use unpivot data by selecting the date columns alone (i.e., column 4 to 7) from the duplicate. I will get Attribute column which contains unique value of dates:
Attribute |
01-01-2011 |
01-02-2011 |
01-03-2011 |
01-04-2011 |
However, if I try to use this attribute column as a filter, it doesn't work!! How can I establish relationship between data in the original table and the attribute column of duplicate table?
P.S. Is there any other way to sort out this issue??? Pls help!
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 |
---|---|
107 | |
98 | |
78 | |
65 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |