Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Avivek
Post Partisan
Post Partisan

Can we filter a % column without using %

I have a report in power bi which is as shown below;

Avivek_0-1611811473790.png

In the above visual, all the Units and Sales are a measure and mix %'s are shown as percent of grand total which is done in the values itself.

Avivek_1-1611811628180.png

 

Now in the filter for the mix % I want to just put the nos such as-

Avivek_2-1611811697429.png

 

But it does not work that way and it is taken as 500%. Instead I have to put as 5% or 0.05. This may be smething I might need to educate the user on. 

But I would like to explore my options if I can use nos directly instad f %.

 

1 ACCEPTED SOLUTION
V-pazhen-msft
Community Support
Community Support

@Avivek 

Create the following column and change the data type from Text to Whole number. Then use the new column as

 

Column = LEFT(FORMAT([%Value],"Percent"),3)
V-pazhen-msft_0-1612148060024.png
 
V-pazhen-msft_0-1612148011555.png

 

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

2 REPLIES 2
V-pazhen-msft
Community Support
Community Support

@Avivek 

Create the following column and change the data type from Text to Whole number. Then use the new column as

 

Column = LEFT(FORMAT([%Value],"Percent"),3)
V-pazhen-msft_0-1612148060024.png
 
V-pazhen-msft_0-1612148011555.png

 

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

 

parry2k
Super User
Super User

@Avivek in this case you will use .05, think about 1 is 100%, .50 is 50% and .05 will be 5%. So you want to use the decimal value when it is %.

 

Check my latest blog post Compare Budgeted Scenarios vs. Actuals 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.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.