Forum Discussion

abhifx's avatar
abhifx
Frequent Visitor
2 years ago

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...
Need Help
danextian's avatar
danextian
Super User
2 years ago

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.

    • danextian's avatar
      danextian
      Super User
      2 years ago

      Hi abhifx ,

       

      It returns blank for the second row because [Total Sales] is blank.

       

      • abhifx's avatar
        abhifx
        Frequent Visitor
        2 years ago

        I might have responded against the wrong reply. This is actually part of the problem as the total sales also get distributed among the sales heads. how to ignore the sub head and add the total? I also need the same to get percentage of each head against sales

  • abhifx's avatar
    abhifx
    Frequent Visitor
    2 years ago

    That is the problem, the total sales is also going to respective sales head instead of switching to Total Sales