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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
sushovan93
Frequent Visitor

Number Flilter not available in Data view for Aug 2022 release

This issue occurs for both existing .pbix files & brand new .pbix files on the August 2022 version. When you are in the DATA view of the model.

 

  • In the .pbix file, go to --> Data view --> click on a table that has columns with different data types.

sushovan93_1-1660214324735.png

 

 

  • We used to be able to filter on columns set as a Whole Number data type.  It seems in the August 2022 version, we can no longer filter on columns that are data type Whole Number

 

 

  • Result of Filter availability:
    • Whole Number - FAIL
    • Text - PASS
    • Decimal Number - PASS

 

 

Data Type: Whole Number

sushovan93_0-1660214301533.png

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@sushovan93 , I doubt there was a filter for the whole number.  Can you check on July 2022

 

View solution in original post

2 REPLIES 2
sushovan93
Frequent Visitor

@amitchandak There was actually!

sushovan93_0-1660237931210.png

 

amitchandak
Super User
Super User

@sushovan93 , I doubt there was a filter for the whole number.  Can you check on July 2022

 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.