Forum Discussion
abhifx
2 years agoFrequent Visitor
Unable to Replace Column data in Matrix Using Switch
Dear All I have been trying to replicate the revenue statement in Power BI directly linked with a trial balance. However once i insert a format and link multi level data into Power BI, I am unabl...
danextian
2 years agoSuper User
Hi abhifx
Have you tried checking whether it is really Total Sale or maybe there spaces before or after or there are more than one spaces between Total and Sale?
You can upload your pbix to Google or One Drive and share a public link.
abhifx
2 years agoFrequent Visitor
That is the problem, the total sales is also going to respective sales head instead of switching to Total Sales