Forum Discussion

Jdogg's avatar
Jdogg
New Member
6 months ago
Solved

Self-Filtering

I have a table from a SQL server. When I want to see specific data via a visual based on a name I select, it self-filters certain things. My table is called WidgetHistory. The column I want to pull d...
Need Help
  • pcoley's avatar
    pcoley
    6 months ago

    Jdogg the report is working as expected. by default, if you select a value in a visualization, that value will filter other visualizations in the report. 
    you can change this adding an ALL or REMOVE in the CALCULATE filters:

    CALCULATE (

    COUNTROWS(WidgetHistory), ALL(WidgetHistory), WidgetHistory[CurrentStatusID] = 23)

    Or changing the interaction between visualizations:

     i hope this help, if so please mark as a solution. kudos are welcome. 

     

v-pnaroju-msft's avatar
v-pnaroju-msft
Community Support
6 months ago

Thankyou, Shravan133, danextian , krishnakanth240 , Ashish_Mathur and pcoley for your responses.

Hi Jdogg,

We appreciate your inquiry through the Microsoft Fabric Community Forum.

We would like to inquire whether have you got the chance to check the solution provided by pcoley to resolve the issue. We hope the information provided helps to clear the query. Should you have any further queries, kindly feel free to contact the Microsoft Fabric community.

Thank you.