Forum Discussion
How to make Dynamic Key column that changes to formula based on user selection?
Hi sbellmore ,
You are on the right track in terms of usage and functionality based on the information you provide.Metrics in Power BI change dynamically based on slicer selections. Metrics are recalculated based on slicer selections and can reflect current user selections.
You can add Custom to the slicer and select Option to make the measure change automatically as needed.
Final output:
How to Get Your Question Answered Quickly - Microsoft Fabric Community
If it does not help, please provide more details with your desired out put and pbix file without privacy information.
Best Regards,
Ada Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hey!
Thanks for the response, it works when you add the metric to a visual. But I guess I need something in Power Query to do the same thing... In Table view on Power BI, If i Go back to Table2, and add column and add column = Concatenated Key -> the result is blank for the entire column. Thats where my problem is. I would like to add it as a column to each table and then do an inner join off that column to get a predifned table with different levels of analysis. not sure if I am asking too much. I very well may be, but I am just trying to teach myself a way to do this. If it is even possible. Thank you So much!