5 Replies Latest reply on Sep 3, 2018 5:12 AM by siva Nageswara Rao

    Label issue

    Sai Sri B

      Hi Team,

       

      I have 2 sheets Main (with donut chart) and Detail(with cross-tab). When I click on any slice in Main sheet then the Detail sheet should be filtered accordingly. It works good so far.

      Issue: I see duplicate labels as highlighted below. When I try to fix the label issue then drill from Main to Detail doesn't work

       

      Attached .twbx

       

        • 1. Re: Label issue
          Mavis Liu

          Hi Sai,

           

          This is because your data needs to be restructured, please go to your data source and pivot the measures. Highlight the columns by using ctrl and clicking, then select right click and pivot.

           

          2018-09-03_11h27_32.png

           

          Doing this will create pivot field names and pivot field values. The first one holds 'black value', 'blue value', etc, and the pivot field values holds the values themselves.

           

          2018-09-03_11h33_26.png

           

          I've done a split on the pivot field name just so I get only the colour name. The I recreated your donut chart.

           

          Thanks and please see the attached workbook.

           

          Mavis

          • 2. Re: Label issue
            Sai Sri B

            Hi Mavis,

             

            Thanks for quick response.

            Unfortunately, I cannot do pivot as I have million of records. Lets say I have 5M records and I would need to pivot it for 5 measures then the count goes 25M which will degrade the performance of the dashboard.

            Is there any way that we can simply fix the issue without pivoting.

            • 3. Re: Label issue
              Mavis Liu

              Hi Sai,

               

              Then you need to create a column with all the values, use this calculation:

               

              IF not ISNULL( [Black Value]) then [Black Value]

              elseif not ISNULL( [White Value]) then [White Value]

              elseif not ISNULL( [Blue Value]) then [Blue Value]

              elseif not ISNULL( [Green Value]) then [Green Value]

              elseif not ISNULL( [Red Value]) then [Red Value]

              elseif not ISNULL( [Orange Value]) then [Orange Value]

              END

               

              Then use this as size in your chart, then remove all your measure values in the mesaure values bucket:

               

              2018-09-03_12h05_18.png

               

              Please see the attached workbook.

               

              Thanks,

               

              Mavis

              1 of 1 people found this helpful
              • 4. Re: Label issue
                Sai Sri B

                Marvis,

                 

                Thank you. This is what I was looking for.

                • 5. Re: Label issue
                  siva Nageswara Rao

                  Sai Sri B

                  Try to implement a COLALESC functionality in the Calculation filed as shown.

                   

                  IF NOT(ISNULL([Black Value])) THEN [Black Value]

                  ELSEIF NOT(ISNULL([Blue Value])) THEN [Blue Value]

                  ELSEIF NOT(ISNULL([Green Value])) THEN [Green Value]

                  ELSEIF NOT(ISNULL([Orange Value])) THEN [Orange Value]

                  ELSEIF NOT(ISNULL([Red Value])) THEN [Red Value]

                  ELSEIF NOT(ISNULL([White Value])) THEN [White Value]

                  END

                   

                  Capture.JPG

                  1 of 1 people found this helpful