cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
admin11
Memorable Member
Memorable Member

How to make my chart Y axis display brand name ?

Hi All

 

admin11_0-1642807230822.png

when convert chart :-

admin11_1-1642807274269.png

How to make Y axis display instead of display 1 to 4 , display Brand name ?

 

My PBI :-

https://www.dropbox.com/s/xbk184omq7qvs9u/SAMPLE_1000_SI_TI_V030.pbix?dl=0

 

Paul 

1 ACCEPTED SOLUTION

Hi,

That reasoning does not make any sense to me.  Sorry.  I can help if you want to get the end result from the source Sales table itself.  I have never appreciate writing calculated table formulas.  The only time i do so is when i have to create a Calendar Table.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

4 REPLIES 4
Ashish_Mathur
Super User
Super User

Hi,

Why have you created 3 calculated tables?  Why not perform all your calculations on the Sales Table itself?


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

@Ashish_Mathur 

You ask a good question, it is because some time table is good for analysis but certain time we need to graphic to see the big different . like those -ve value. 

Reasons i using Table 1 , is because i try to make use of dynamic dimension. so user can analyse by brand or segment in on table or chart.

 

Paul

Hi,

That reasoning does not make any sense to me.  Sorry.  I can help if you want to get the end result from the source Sales table itself.  I have never appreciate writing calculated table formulas.  The only time i do so is when i have to create a Calendar Table.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

@Ashish_Mathur 

Okay i agree with your explanation ,  my approach is wrong. Thank you

 

Helpful resources

Announcements
Power BI Show Ep 4 Post Show Carousel.jpg

The Power BI Community Show

Shabnam Watson demos Incremental refresh & Hybrid Tables and Leila Etaati demos Charticulator.

PBI April Release 2022 768x460.png

Check it out!

Click here to read more about the April 2022 updates!

Power BI Dev Camp Session 22 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!