Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi everyone,
I am building a model to help me choose which container I need to use based on the material I want to ship and the average temperature of the sending and receiving ports. for a certain product if it's too hot say >30 degC (this threshold depends on the selected product) it needs to go on temperature controlled containers, else in ambient containers.
The tables are not linked so i guess it's not possible but maybe someone has an idea...
Is there a way to achieve this?
I could do it in excel but translating it to here is proving quite difficult for me 😞
thanks!!!
Solved! Go to Solution.
If you can do it in Excel, keep doing it in Excel. Power BI is not a logistics planning tool.
HI @nicoenz,
AFIAK, current power bi can create measure expression to show the correspond result based on condition and filter interactions in visuals, but it does not support to create dynamic calculate column/table based on filter effects. (they do not work on the same level and you can’t use the child level to affect their parent)
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
HI @nicoenz,
AFIAK, current power bi can create measure expression to show the correspond result based on condition and filter interactions in visuals, but it does not support to create dynamic calculate column/table based on filter effects. (they do not work on the same level and you can’t use the child level to affect their parent)
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
If you can do it in Excel, keep doing it in Excel. Power BI is not a logistics planning tool.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
65 | |
63 | |
56 | |
39 | |
27 |
User | Count |
---|---|
85 | |
58 | |
45 | |
43 | |
38 |