Forum Discussion

cprine's avatar
cprine
Frequent Visitor
5 years ago

Filtering table visual from bar chart not working

Hello,   I created a measure to get a distinct count of customer master records with no credit limit.    Unique Customers without Credit Limit = CALCULATE(DISTINCTCOUNT(CUST_CREDIT_LIMIT[CUSTOME...
Need Help
cprine's avatar
cprine
Frequent Visitor
5 years ago

Thanks for your responses. Yes, I made sure the interactions are setup to filter the table from the bar chart. There is only a single data table so no joins needed. The only solution that has worked is creating a conditional column for "Credit Y/N" and adding a visual filter to the bar chart for the "N" records. It works for now, but is a temporary fix for times' sake. This issue still bothers me though, because I haven't encountered this issue with my other PBI projects, and I don't know what the root cause is. For that reason, I'm leaving this issue as unresolved. 

  • HotChilli's avatar
    HotChilli
    Community Champion
    5 years ago

    Did you "hover the cursor over the funnel icon above the table to see if the filters are affecting the visual."?  

    I suspect the 2nd part of my answer is what's happening i.e. the table is being filtered but not in the way you expect (probably by region)

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi cprine,

    Perhaps you can share a pbix file with some dummy data and we can do test to troubleshoot on it. It is hard to test,reproduce and confirm where issue is without any same data.

    Regards,

    Xiaoxin Sheng