Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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:
User | Count |
---|---|
52 | |
46 | |
20 | |
16 | |
13 |
User | Count |
---|---|
108 | |
54 | |
31 | |
20 | |
18 |