Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello PBI Community Good Day!
Per the screen shots from my sample .pbix below, I have created a view with Sales and Revenue in a matrix visual with ease. However, when I use Analyze in Excel to create the same view, I can’t use the SnR Amount. I have to use my ( Total Sales and Total Revenue) Key Measures I have created.
*****Screen Shot 1******
What I’m trying to accomplish:
To create the same view per my .pbix above in Analyze in Excel.
What I have accomplished so far.
I have been able to create a similar view in Analyze in Excel, but my Sales and Revenue are staggered. Screen Shot 2
I need help with creating one measure that combines both measures to give me the view I have in Screen Shot 1 ( Sales and Revenue stacked and align under each other).
****Screen Shot 2******
Here are the measues for Sales and Revenue:
Much appreciate your time per this matter!
Thank you
@PBI-Curious Take Values out of your Columns field well?
Hello Greg_Deckler
Not sure what you mean per you comment below.
Take Values out of your Columns field well?
Also, How can I upload a sample .pbix?
Here are my measures. Can you provide an example?
Thank you
@PBI-Curious In your Excel pivot table you have 2 things in the Columns field well, Values and Year. I am saying take Values out of that field well.
Hello Greg_Deckler
Good Day!
When I take out value from the column field well, my Total Sales and Total Revenue numbers disappear.
see screen shots below
Note: I'm creating my pivot in Analyze in Excel
Before
After:
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 |
---|---|
56 | |
27 | |
23 | |
15 | |
11 |
User | Count |
---|---|
78 | |
63 | |
47 | |
17 | |
12 |