Forum Discussion

akshah's avatar
akshah
Frequent Visitor
8 years ago

Custom details for Pie Charts

        I want to seggregrate Remaining into [roofs, tanks and ships] just want to add these three details inside the remaining part  Is there any way to just add details to the remaining part...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Could you add a custom column to your data set to use for the grouping instead, something like:

 

Group Column = if('Table'[Solar-Ready]="Remaining", CONCATENATE("Remaining - ",'Table'[DetailColumn]),'Table'[Solar-Ready])

 

Then use this instead of the solar-ready column you're currently grouping on?

akshah's avatar
akshah
Frequent Visitor
8 years ago

Thank You So Much, But all the detailed field are each indiviual columns in different table  and its showing error.

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago
    Can you give an example of your dataset?
    • akshah's avatar
      akshah
      Frequent Visitor
      8 years ago

      Here is the file which pie chart is madeHere is the detailed file i need for detailsf

       

      So there are two different tables. Summary is the one which PIE chart is made up of 

      And Schedule is the one in which i have to add Detailes in PIE Chart. [ I just need "In Progress","New Roof" "and "Planned"]

       

       

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        8 years ago

        Hi akshah,

         

        Do these two tables connect?

        What's the expected result? Adding them as a tooltip? Or adding them as slices.

         

        Best Regards,

        Dale