Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!View all the Fabric Data Days sessions on demand. View schedule
Hi All,
Could someone please help me on the below.
I have a excel file which has the data as below screenshot.
now based on the Unit i have to get the region in the power bi as if unit =F western Europe it should be under germany and region as Europe. it should as europe--germany--Western Europe.Could someone please let me know how to write the condition in power bi to get this.
Regards
Anitha.
Hi @anithaMallam ,
Please provide the data that can represent your data model and the results you expect based on this data.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If you could provide sample .pbix file that should help provide quick work on the solution.
Regards
Kumail Raza
Hi,
As of now i dont have the Pbix file.i was given the excel file to create the pbix report.
Regards
Anitha
Send the xlsx file and any working that you have done in power BI. If not, just send the xlsx file
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!