Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello All,
I have one question and i am not sure is it possible in power bi or not.
There is a column of user name in table and i want to specify some criteria to it based on user selection.
Eg. Column name is user name and i have created one table name Selection.
I want to add user name to selection which i have made.
Suppose username is Cat and in selection there are 2 dropdowns Animal and Not animal.
So if someone selects Animal then value sholud be added to animal field in selection.
In this way i want dynamic value based on selection ,
PLEASE HELP, IF WE CAN APPLY THIS IN POWER BI OR THERE ARE SOME OTHER WAYS TO ACHIEVE.
Thanks.
Hi @MiteshY,
Current power bi does not support create dynamic calculated column/table based on filter selection, you may need to write measure formula that can be interacted with filter selection to instead.
Notice: the data level of power bi(from parent to child level)
Database(external) -> query table(query, custom function, query parameters) -> data model table(table, calculate column/table) -> data view with virtual tables(measure, visual, filter, slicer)
Regards,
Xiaoxin Sheng
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
3 | |
3 | |
2 | |
2 | |
2 |
User | Count |
---|---|
10 | |
4 | |
4 | |
3 | |
3 |