Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to hide data dynamically based on a number of data

Hi everyone,   I don't know if this was asked earlier, but seems to me I can't find the solution for the following problem. The problem I'm facing is I that need to dynamically hide or show data b...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    4 years ago

    Hi Anonymous 

     

    Download sample PBIX file

     

    You haven't supplied any sample data so I've recreated my own and it's obviously not going to match yours.  However, with my data I have created a measure that calculates the Total Units Sold per month.

    Total Units Sold = CALCULATE(SUM('DataTable'[Units Sold]), FILTER(ALL('DataTable'), 'DataTable'[Date] = SELECTEDVALUE('DataTable'[Date])))

     

    This is then added as a filter to the clustered column visual

     

    So now if any columns don't have in excess of 250,000 total units sold across all products, that column is not displayed.

     

    Try this with your data, see my attached file for reference.  If you can't get it to work please post back with some sample data.

     

    Regards

     

    Phil

v-henryk-mstf's avatar
v-henryk-mstf
Icon for Community Support rankCommunity Support
4 years ago

Hi Anonymous ,

 

I have done the testing and think the solution provided by PhilipTreacy  is worthy of reference. 


If the problem is still not resolved, please point it out. Looking forward to your reply.


Best Regards,
Henry