Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I've built a report with a Sales fact table, which have several flag (BIT type in SQL Server) columns in my model, for exemple Local, Bio etc....
When I create slicers with these columns, as shown below, it displays True / False on all my columns slicers, and instead of it I would like to see Yes / No.
Is there a way to customise this ?
Or at leat, to translate these labels (as my report is not in English).
Thank you
Solved! Go to Solution.
Add calculated columns that "translate" the 0/1 values into what you want to display. Then use the new columns for your slicers.
Add calculated columns that "translate" the 0/1 values into what you want to display. Then use the new columns for your slicers.
This is what I've done for all my BIT columns.
Thank you
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
112 | |
96 | |
95 | |
67 | |
65 |