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.
I have trouble create a table with varying number of columns.
Say I have the following dataset containing some sales data
Customer ID | Country | Customer group | Number of products bought
How do I create a table where I can use slicer such that with I select all customer ID and customer group, the two columns will disappear in the table and leaving only country | number of products?
Solved! Go to Solution.
Hi @tmv3v ,
If you wanna use a table visual, based on my research, it is not supported yet for now. But you can post an idea here.
https://ideas.powerbi.com/forums/265200-power-bi-ideas
But in the meanwhile ,I can show you a workaround where you can make 2 columns disappear when you select all the the columns in a slicer.
Steps are as below:
Measure = IF(ISFILTERED('Table'[Customer group])&&CALCULATE(COUNT('Table'[Customer group]),ALL('Table'))=CALCULATE(COUNT('Table'[Customer group]),ALLSELECTED('Table'))&&MAX('Table (2)'[Column1])="Customer group",BLANK(),IF(ISFILTERED('Table'[Customer ID])&&CALCULATE(COUNT('Table'[Customer ID]),ALL('Table'))=CALCULATE(COUNT('Table'[Customer ID]),ALLSELECTED('Table'))&&MAX('Table (2)'[Column1])="Customer ID",BLANK(),SUM('Table'[Number of products bought])))
2.Choose a matrix, and pick the fields as below:
3, Finally when you select all the columns ,they would “disappear ” in the Matrix.
For the related .pbix file,you can turn to URL:
Hope this would help.
Best Regards,
Kelly
Hi @tmv3v ,
If you wanna use a table visual, based on my research, it is not supported yet for now. But you can post an idea here.
https://ideas.powerbi.com/forums/265200-power-bi-ideas
But in the meanwhile ,I can show you a workaround where you can make 2 columns disappear when you select all the the columns in a slicer.
Steps are as below:
Measure = IF(ISFILTERED('Table'[Customer group])&&CALCULATE(COUNT('Table'[Customer group]),ALL('Table'))=CALCULATE(COUNT('Table'[Customer group]),ALLSELECTED('Table'))&&MAX('Table (2)'[Column1])="Customer group",BLANK(),IF(ISFILTERED('Table'[Customer ID])&&CALCULATE(COUNT('Table'[Customer ID]),ALL('Table'))=CALCULATE(COUNT('Table'[Customer ID]),ALLSELECTED('Table'))&&MAX('Table (2)'[Column1])="Customer ID",BLANK(),SUM('Table'[Number of products bought])))
2.Choose a matrix, and pick the fields as below:
3, Finally when you select all the columns ,they would “disappear ” in the Matrix.
For the related .pbix file,you can turn to URL:
Hope this would help.
Best Regards,
Kelly
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 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |