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 Dear Power Team ;
İ need your help about below issue.
İ have a table in excel as below :
İ created a dashboard with a matrix table on power bi and show that table on dashboard.
My problem is when the column names changed the table is not working.
İ am always looking for per 3 months on the table.
For example after i created that table this month , next time i will check for the months : July,August,September so in excel in A column will be July and then B column will be August and then C Column will be September.
So is there any way when i change the column name in excel in my dashboard the names will change automaticly too.Also in my table in power Bi too.
thanks for your kindly supports dear friends , i will wait for your infos.
Erhan
Hi @erhang,
I think you can unpivot columns to convert column to list, I think unpivoted table can simply to calculate in dax formula.
Unpivot Data Using Excel Power Query
Current power bi not contains features which you wanted.
Regards,
Xiaoxin Sheng
You might consider just pulling in 12 months of data every time and filtering it out correctly in Power BI.
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |