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.
I have a card that is displaying aggregated sales data by market and for some reason has an odd trailing "\" behind the M or K (depending on Millions or Thousands). It will display "1.52M\" rather than just "1.52M". Has anyone run into this or know a fix?
Solved! Go to Solution.
Hi @bpopwell ,
You can try replacing the "\" backslash with space in your data in Power Query editor.
Thanks,
Pragati
Hi @bpopwell ,
Based on my test, such a trailing backslash does not appear on my side.
I doubt the "\" is already existed in your original data. Please check the pbix file(to see the data) on Power BI Destop.
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @bpopwell ,
You can try replacing the "\" backslash with space in your data in Power Query editor.
Thanks,
Pragati
I'm using Power BI Service and am unable to open the Power Query Editor - is there another way?
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.