The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Hi,
I want to change the names in the Legend to some custom names. How do I do that? The data is not available in the PPI-DCL spreadsheet.
Furthermore, the data will be refreshed every month, so the solution needs to take that into account.
I look forward to read your response.
Thank you in advance, much appreciated.
Solved! Go to Solution.
If your data is being imported via spreadsheets, you can do it by transforming ("Replace Values") in the Query Editor. It will persist throughout your data refreshes as long as the original names in the spreadsheet do not change.
If your data is being imported via spreadsheets, you can do it by transforming ("Replace Values") in the Query Editor. It will persist throughout your data refreshes as long as the original names in the spreadsheet do not change.
Hi tjd,
Thank you so much for your help. It was way easier than I expected.
Have a nice day!