Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
rsomoza
Regular Visitor

Get value from cell based on its row and column combination

Hey guys

I’d much appreciate your help on this, as I’m new on PowerBI.

 

I’d like to have the option to compare the same two metrics depending on the column combination. I have created a very simple example in excel…

 

2017-12-19_1013.png

 

So basically, I want to obtain for each area (row) the value from “season 1.value Y”, and also get the value from “season 2.Value Y” and be able to later compare them with a visualization that allows me to set a target and an actual value, being in this case my target “season 1.value Y” and my actual “season 2.Value Y

 

Value Y es one value, the same that repeats depending on the season.

 

Is it possible to get the value from a particular "cell" and then use it later? Let me know if you need further clarification!

Thanks!!!

7 REPLIES 7
Greg_Deckler
Super User
Super User

So, what you want to do is get your data in a format like this:

 

Area,Season,Value X,ValueY

area1,season1,1,1

area1,season2,3,2

area2,season1,2,2

area2,season2,2,3

area3,season1,1,1

area3,season2,1,2

 

 


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Hi smoupre

 

Yes I need a way to get the values based on the season and the area. So I can compare, for example the value Y result "1" from the first row with the value Y restult "2" from the second row...and later use the value to compare or visualize if the second one is higher, lower or same....

 

row1: area1,season1,1,1

row2:  area1,season2,3,2

 

🙂 Is there a way?

 

 

Any ideas? is it possible to handle values like this in Power BI??

 

Cheers!!

What smoupre means is to start with loading data in a tabular form. So make sure you have a table with columns Area, Season, ValueX, and ValueY (see his example); or even with columns Area, Season, X/Y, and Value. When you do this, you can create reports with e.g. a table with Area and ValueY, and Power BI will aggregate the ValueY values by area:

 

Area,   Sum of ValueY

area1  3

area2  5

area3  3

 

When your data is in a different format, the Power BI Get Data experience (Power Query) can transform it into the format you need.

 

Thanks.. but I think that maybe my goal was not properly explained.

 

2017-12-21_1315.png

 

I have two seasons and I want to compare the units we sold in each of them. I do have above idea of a report in my PowerBI. Data is accurate.

 

What I'd like to know if there is any way to get value 6 and separately get value 10 and compare them using a KPI vizualization. There is one visualization (KPI Visualization) that allows me to compare a Target and an Actual by something (season)... I want to use the Target as value 6 and Actual as value 10. I can't just use Units in the visualization because it is the same information for season but with different results.

 

I know that are other tools that allow user to get and use the values using variables, but not sure if it is the case of PowerBI, or if there is any other way to handle those numbers.

 

I much appreciate your help!

 

Any ideas on how to be able to compare both values in a matrix? like for example, to show as percentaje how is value area1.season2.units compared with value area1.season1.units

 

O putting this in other words, I'd like to have this result:

 

(('area1.season2.units ' * 100) / 'area1.season1.units')

 

thanks!

Trying one more time this one, please check my last post...

 

thanks!!

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.