Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
Love the drill down function of PowerBI. Is it possible to have below table in excel in 1 PBI table?
Below is what I get using PBI vs one I need in excel.
Sample file attached.
Just trying to understand your question. Is it that you are pretty close with your Power BI table except for the cells in the Excel image where the numbers are red?
eg, for the top row SMT for the 4/25/2017 excel is showing 9% whereas PBI is showing 1.2%
To me all the other numbers look good.
Hi @Phil_Seamark,
Any luck?
I was able to get the values at the top by creating a 2nd table (Excluding "Line"). Nonetheless, was hoping to achieve the same calculation with just 1 addtional table or no additional table (using original "data" table). Still unable to get the values on the right.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
102 | |
86 | |
77 | |
70 |
User | Count |
---|---|
120 | |
108 | |
98 | |
83 | |
77 |