Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi All,
We have Region,Country,Port Columns for Origin and Destination.
O_Region,O_country,O_Port , Region_D,Country_D,Port_D are columns for Origin and Destination.All are in one table.I have a requirement like,if I click on Region Button from Origin and Region Button from Destination,then it should show all the transactions from that Origin Region to Destination Region.If I click on Region from Origin and country from Destination then it should show transactions from Origin Region to Country Destination.If I click on Port from Origin and Region from Destination,then it should show transactions from Origin Region to Country Port.
I need to display the combination is like this,
Region to Region
Region to Country
Region to Port
Country to Region
Country to Country
Country to Port
Port to Region
Port to Country
Port to Port
I have achieved it by doing Unpivot for Region,Country,Port for Origin and Unpivot for Region,Country,Port for Destination.These steps are adding more rows.I have huge amount of Data.
So,Can any one please suggest me any other way for this?
@Anonymous
Do not worry about a huge number of rows, large numbers of columns will make your model slower. If works for you fine.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Is there any intelligent way to handle it with Pivoting the complete data . through some Dax any reference will be helpful.
In my case there are 12 columns and I need to Pivot two columns againts those 10 columns and each granular data has 12 Millions rolws . This becomes difficult to refresh the data on service.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
78 | |
63 | |
52 | |
47 |
User | Count |
---|---|
212 | |
82 | |
61 | |
61 | |
60 |