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.
Dear:
I have a query, I have made some crosses with a table that I have, which is called Key Players, which are some of the products that I want to evaluate, it is not the total of the universe, but obviously since I do not have some of the competitors in that table, A blank box appears. How could I make sure that instead of the White in the first row showing me the word "OTHERS", the measure I am using for the calculation is:
Thanks in advance for the prompt response
Solved! Go to Solution.
You need to have "Others" in the KEY_PRODUCT column if you want it to be displayed. You could add a new column to data table to group products except for the five listed products into a group "Others", then use this new column as row field in the matrix visual.
Group column =
IF (
'table'[KEY_PRODUCT]
IN { "ProductA", "ProductB", "ProductC", "ProductD", "ProductE" },
'table'[KEY_PRODUCT],
"Others"
)
Additionally, if you hope the "Others" group to be dynamic as you would change key products with a slicer or filter, you could refer to the following blog. It has a great solution there.
Dynamic Grouping in Power BI using DAX – Some Random Thoughts (sqljason.com)
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
You need to have "Others" in the KEY_PRODUCT column if you want it to be displayed. You could add a new column to data table to group products except for the five listed products into a group "Others", then use this new column as row field in the matrix visual.
Group column =
IF (
'table'[KEY_PRODUCT]
IN { "ProductA", "ProductB", "ProductC", "ProductD", "ProductE" },
'table'[KEY_PRODUCT],
"Others"
)
Additionally, if you hope the "Others" group to be dynamic as you would change key products with a slicer or filter, you could refer to the following blog. It has a great solution there.
Dynamic Grouping in Power BI using DAX – Some Random Thoughts (sqljason.com)
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
@Syndicate_Admin , You need to have product or competitors in the table(dimension table, on on row) with others, if you want to display other in place of blank
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |