Forum Discussion

NameTaken's avatar
NameTaken
Frequent Visitor
10 months ago
Solved

Reference Label as a percent

Hello,    I have Customer Groups and then Individual Customer as slicers in my report. I can currently take the entire customer portfolio, say its 100, and the amount of a Customer Group (call it ...
Need Help
  • v-hjannapu's avatar
    v-hjannapu
    9 months ago

    Hi NameTaken,

    I have reproduced your requirement and implemented the solution. I have attached the PBIX file for your review so you can see the updates. Let me know if you need any changes or further improvements.


    Regards,
    Community Support Team.

     

v-hjannapu's avatar
v-hjannapu
Community Support
10 months ago

Hi NameTaken,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We are always here to support you.


Regards,
Community Support team.

NameTaken's avatar
NameTaken
Frequent Visitor
9 months ago

My apologies for not being able to get back to this sooner. 

The solution seems to not work with the Created Date Slicer like the Purchase Count Total measure. 

When using the Created Date the answer was no longer correct so I think I need to add something to keep that filter.
However when I added: 

KEEPFILTERS(VALUES('Volume'[CustomerGroupName])),
    'Volume'[CreatedDate] >= MIN('Volume'[CreatedDate]),
    'Volume'[CreatedDate] <= MAX('Volume'[CreatedDate])
)
 
the calculation no longer produces the correct answer at all. I need the reference label to respect the Created Date slicer like everything else on the page does. 
  • v-hjannapu's avatar
    v-hjannapu
    Community Support
    9 months ago

    Hi NameTaken,

    I have reproduced your requirement and implemented the solution. I have attached the PBIX file for your review so you can see the updates. Let me know if you need any changes or further improvements.


    Regards,
    Community Support Team.

     

    • v-hjannapu's avatar
      v-hjannapu
      Community Support
      9 months ago

      Hi NameTaken,
      Hope the information provided helps resolve your issue. If you have any further questions or need additional assistance, please don’t hesitate to contact us. We are always happy to help.

      Regards,
      Community Support Team.