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.
Hi All,
I have two tables: Fact_Actual and Options. These two data tables have no relationship at all.
In the dashboard, I will have a table and slicer. Table contains only [Value] and [Selection] will be the filter.
If I filter Selection="Yes", I only want to see A+B value
If I filter Selection="No", I olny want to see C value.
If I filter Selection="Maybe", I olny want to see D value.
How can I achieve it? Thanks!
Regards,
BK
You could create a new column within the Fact_Actual table. The logic is below:
Hi @S_JB , thanks for the reply. There will be more data than A-D, it will be troublesome to do this method
Hi, @Anonymous
I'm not sure what you mean by "it will be troublesome".
According to the information you provided,using the if statement to judge is the most direct solution.
Best Regards,
Community Support Team _ Eason
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |