[HELP] Unable to fetch values in slicer

[Anonymous]

Hello Folks,

I need help with slicer. I have a calculated colum (custom column).

Example:

UID	CustomColumn
1010	10
1020	20
1030	30
1040	40
1050	50

I have created the custom column by extracting last two digts from the column - UID.

I need to have a slicer so the report can be filtered based on the selection in the custom column. If not slicer, what could be the best possible way?

TIA 🙂

[Anonymous · Accepted solution]

Update: Encountered some issues with the tool. Formulas were also not working at one point. Re-installed PowerBI and everything is working fine. No idea why did the tool behave that way. Thanks everyone 🙂

[davehus]

Have you tried adding the customer column to the slicer visual?

[parry2k]

@Anonymous not sure what you are trying to achieve, why you cannot use the slicer on this custom column? I must be missing something here.

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.