Forum Discussion

AndrewPF's avatar
AndrewPF
Helper V
2 years ago
Solved

change variable from text to numeric - visual filter no longer works

I have a basic bar chart with business name as X-axis and score as Y-axis. 

I have also applied some filters to restrict the data being displayed. 

One of these filters used a field of type text. 

However, when I changed the field to Int64.Type, the visual seemed to ignore the filter. 

I have tried reapplying the filter.  I have tried changing the filter from basic to advanced.  I cannot get it to work. 

Does anyone know what's happening?  This feels like a bug. 

I have the latest version of Power BI. 

Need Help
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    Hi AndrewPF 
    Text and numbers filters are behaving differently.
    The text has functionalities as :

    When at numbers you should use mathematical operators + logical and/or

    So if you change the data type of your filter field you need to modify it according to its options.
    For a more detailed explanation please attach a link to some dummy file.
    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

     

     

1 Reply

  • Ritaf1983's avatar
    Ritaf1983
    Super User
    2 years ago

    Hi AndrewPF 
    Text and numbers filters are behaving differently.
    The text has functionalities as :

    When at numbers you should use mathematical operators + logical and/or

    So if you change the data type of your filter field you need to modify it according to its options.
    For a more detailed explanation please attach a link to some dummy file.
    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly