Forum Discussion

IF's avatar
IF
Post Prodigy
5 years ago

2 values in axis

Hi Everyone,   I checked the post but could not find the one that I really want to do.   I have the following example data: name category PTIme KTime Price KPrice john a 1 1 10 1...
Need Help
Icey's avatar
Icey
Community Support
5 years ago

Hi IF ,

 

I can't download your file.

 

Can't you open the file attached under my last reply? There are some changes in it. If you can't open it, I will explain what I did in details.

 

 

Best Regards,

Icey

IF's avatar
IF
Post Prodigy
5 years ago

Hi again,

 

What you provided is very clear. When there are different names and same categories, then it doesn't work. For example;

 

name

category

PTIme

KTime

Price

KPrice

john

a

1

1

10

160

john

b

1

2

15

150

john

d

2

3

16

160

john

e

2

3

18

190

john

f

3

3

20

180

john

g

4

5

23

160

john

h

4

6

26

110

john

i

5

7

30

140

john

j

6

7

32

130

john

k

6

7

35

120

john

l

7

7

39

100

Maj

j

12

3

50

80

Maj

k

16

2

55

70

Maj

l

15

1

60

50

I added last three rows. I added new columns to the power bi file as well:

PTime2=[PTIme]*[Price]/[Price]

Ktime2=[KTime]*[KPrice]/[KPrice]

Let's look at category "j". If no name is selected, it should be shown under Ptime2: value 10 and Ktime2:value 5 based on the formula or new columns that I explained (there are two values for category j: one for John and one for Maj). If John is selected, it should be shown under Ptime:5, KTime:7. 

 

Here is the new link from dropbox:

https://www.dropbox.com/s/mzm9w83cz1wf0pl/2%20values%20in%20axis%20-%20increaseddata%202.pbix?dl=0

I tried this link but it works for me:  https://gofile.io/d/V8Fonh

I hope one of them works for you at least.

 

I hope it is clear and you can find a solution. 🙂

 

regards,