Forum Discussion

zblm's avatar
zblm
Frequent Visitor
8 years ago
Solved

Dynamic Groupings

Hi all,     Im hoping someone can help me. I have a pie chart that displays counts of claims by days of the week. Most of the data falls between Monday to Friday, with only a small amount of data ...
Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    8 years ago

    Hi zblm,

    You add a measure in the value level of the pie chart, right? If it is, you can create try to create another measure using the formula below and replace it to original measure to check if it works fine.

    newmeasure =
IF (
    Table[Date] = "Saturday"
        && Table[Date] = "Sunday"
        && [your_measure] <= 0.05,
    CALCULATE ( [your_measure], FILTER ( Table, Table[Date] = "Saturday" ) )
        + CALCULATE ( [your_measure], FILTER ( Table, Table[Date] = "Sunday" ) ),
    [your_measure]
)


    Please respond me if you have any problem.

    Best Regards,
    Angelia

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
8 years ago

Hi zblm,

You add a measure in the value level of the pie chart, right? If it is, you can create try to create another measure using the formula below and replace it to original measure to check if it works fine.

newmeasure =
IF (
    Table[Date] = "Saturday"
        && Table[Date] = "Sunday"
        && [your_measure] <= 0.05,
    CALCULATE ( [your_measure], FILTER ( Table, Table[Date] = "Saturday" ) )
        + CALCULATE ( [your_measure], FILTER ( Table, Table[Date] = "Sunday" ) ),
    [your_measure]
)


Please respond me if you have any problem.

Best Regards,
Angelia

  • zblm's avatar
    zblm
    Frequent Visitor
    8 years ago

    Hi Angelina,

     

    Unfortunatley i couldnt get thta measure to work. I couldnt figure out how to refernce "Table[Date] = "Saturday"", etc.  seeing as for me its usually just Staurday or Sunday that cause the issue, I created a new grouping and sorted it accordingly.

     

    Thanks very much for the reply.

    • v-huizhn-msft's avatar
      v-huizhn-msft
      Microsoft Employee
      8 years ago

      Hi zblm,

      Based on my understanding, there is a column in your resource table including "Monday", "Tuesday", "Wednesday", "Thursday", "Friday",""Saturday" and "Sunday", so place the column to Table[Date] in my formula. You said you created a new grouping and sorted it accordingly,  welcome to share your solution and mark it as answer, so more people will benefit from here.

      Best Regards,
      Angelia