Forum Discussion
Post PartisanFilter based on a marker
i have a coloum in the data that shows if the data is of a certain type. and marks it with a 1 or 0
By defaul i would like my page to show all data, but i would like to select and swith between show only the data with a 1 in the marker coloum.
e.g a fiter to show either all or exclude the 0 in the coloumn.
im a bit lost!
Hi NewbieJono ,
You can refer the following links to get the column with the value 0 or 1:
Create a FLAG column with 1 or 0
If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.
How to upload PBI in Community
Best Regards
1 Reply
Hi NewbieJono ,
You can refer the following links to get the column with the value 0 or 1:
Create a FLAG column with 1 or 0
If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.
How to upload PBI in Community
Best Regards