Forum Discussion
Power BI dynamic visualizations
Power BI cannot work with encrypted Excel files.
Confidential - Microsoft Extended:DESCRIPTION Data is classified and protected. Microsoft Full Time Employees (FTE) and non-employees can edit, reply, forward and print. Recipient can unprotect content with the right justification.
Input1-MainTable :
| col1 | col2 | col3 |
| a | a1 | a2 |
| a | a1 | b2 |
| a | b1 | c2 |
| b | b1 | d2 |
| b | c1 | e2 |
| b | c1 | d2 |
input2-UserselectedColumns :
| ColumnName |
| col1 |
| col2 |
| Viz1 | Viz2 | |||||
| Col1 | Count | Col2 | Count | |||
| a | 3 | a1 | 2 | |||
| b | 3 | b1 | 2 | |||
| c1 | 2 |
pk3130 Hey,
I will follow below method as per your latest input.
1) Make sure you have a parameter table that lists all columns
2) Use the UserselectedColumns[ColumnName] to create a slicer where users can select multiple columns.
3) Create measures for dynamic counting based on selected columns.
Col1Count =
VAR SelectedCol1 = SELECTEDVALUE(UserselectedColumns[ColumnName], "col1")
RETURN
CALCULATE( COUNT(MainTable[ColumnName]), MainTable[True] = TRUE() )
4) Ensure each table visual dynamically interacts with the selected column measure.
5) Use columns col1 and colcount1 for your first table visual.
follow by rest column
Thanks
Harish KM
If these steps help resolve your issue, your acknowledgment would be greatly appreciated.