Forum Discussion
Use slicer to show only certain values
Thank you so much for the help, based on it all I was able to find this topic. Which did the trick for me. So did not have to update the data.
It should be just selecting one customer, but depending on the customer chosen it is depending on the column that should only display the ones and hide the zero's.
- MFelix
Super User
Hi Senti79 ,
Not sure how you have the setup if it's a single table or more than one table but assuming you have a single table you can do the following:
I assume your table is similar to this:
- Create a slicer with the customer column
- Select single select for the options
- On the matrix do the following setup:
- Rows: Application
- Columns: Customer
- Values: Values
- Filter of values different than 0
If you model is not in a single table please give some more context if you can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.
If the information is sensitive please share it trough private message.Sadly it is not in an easy way setup. In the base data in the column customers it is entered which customer is using the application. This is done by specific numbers or by mentioning the word all. In Excel I have the formula next to that per column to put a one if the customer is mentioned for that application or if it is mentioning all. That part is working fine. I hope this clarifies.
- MFelix
Hi Senti79 ,
How is the data in Power BI can you provide a sample?
I believe that you need to do some data cleanup or some additional filtering on the formula to calculate the values you need. But this will depend on how you have your data and if is possible to change it in Power BI or not.
Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.
If the information is sensitive please share it trough private message.
