Forum Discussion
Helper IIHow to dynamically create a column in the visual based on the slicer Selection ?
Hi All,
In my report, I have 2 slicers namely 'Service Name' and 'Service Group'. When I filter the data by selecting one value in the 'Service Name' slicer, automatically a new column should be generated by displaying the corresponding form values according to the slicer selection. Similarly, when we do multiple selections (Say two) in the 'Service Name' Slicer, then automatically two columns should be generated for displaying that corresponding data (One column for one slicer value and second column for the another slicer selection).
Generally, the no of new columns should be generated based on the no of selected values in the slicer.
Ultimately, this should be done for the 'Service Group' Slicer also. Can we do this in Power BI using DAX functions ?
Is there any way or solution to implemet this in power BI ?
Please share your thoughts on this.
Any pointers on this would be of great help!
Thankyou in advance !!
3 Replies
- amitchandak
Super User
Madhumitha_V , I doubt you can add a new column. But if you are using it on the column of the matrix the values can add based on slicer selection
Madhumitha_Vamitchandak , But every new column that is going to be created based on the slicer selections will be having multiple values not just a single value. How can we do that ? Is there any way we can approach that ?
- Greg_Deckler
Community Champion
Madhumitha_V - Sorry, having trouble following, can you post sample data as text and expected output?
This might help: https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-EVERYTHING-measures-axis-legend-titles-chart-types/m-p/1027881#M444
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
