Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hey, I have a slicer that is based in a calculated column that I use to filter some tables. That column "Equal" only have 2 options, Yes and No. In some months only appears one option, but i want to appear always Yes and No in the slicer.
It is possible to do this ?
In May,
In April,
The table i used to build the example.
Sorry for my English !
Thanks for any help!
Solved! Go to Solution.
Hi @edubcardoso
You can create a table using Enter data and map that table with the one which has email column.
And use the Email column from new table , that way u'll always see yes and No.
Hi @edubcardoso ,
Since in the data for April, you have only "YES" value it is showing one thing in the slicer. If you want to show both "YES" and "No" then you can follow the below steps:
1- create a new table using enter data:(screenshot -> click on enter data -> enter values-> load):
and then click on load.
Step 2:
make a relationship between this new table & "Equal" column:(screenshot) Modelling -> Manage Relationship
make relationship between Equal column and the new column that is coming from the new table that we created
Step 3: take value in the slicer from the new table.
@edubcardoso -> Please hit the thumbs up and mark it as a solution if this helps you. Thanks.
Hi @edubcardoso
You can create a table using Enter data and map that table with the one which has email column.
And use the Email column from new table , that way u'll always see yes and No.
I'm sorry, but it didn't get it.
What do you mean by "email column" ?
Hi @edubcardoso ,
Since in the data for April, you have only "YES" value it is showing one thing in the slicer. If you want to show both "YES" and "No" then you can follow the below steps:
1- create a new table using enter data:(screenshot -> click on enter data -> enter values-> load):
and then click on load.
Step 2:
make a relationship between this new table & "Equal" column:(screenshot) Modelling -> Manage Relationship
make relationship between Equal column and the new column that is coming from the new table that we created
Step 3: take value in the slicer from the new table.
@edubcardoso -> Please hit the thumbs up and mark it as a solution if this helps you. Thanks.
It worked!!
Thanks truptis 😊
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |