Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
60 | |
58 | |
54 | |
36 | |
33 |
User | Count |
---|---|
79 | |
66 | |
45 | |
45 | |
43 |