What a fantastic video! Your crisp and clear explanation turned something that takes years to understand into a 10-minute masterpiece. Truly unbelievable skills! As someone from Telugu land, I feel incredibly proud to see your brilliance shine on such a platform. Keep inspiring us with your incredible talent!
@3:49 i thought that x -axis has to be always to be a time based column but i worked on a datset in which i have to put countries in x-axis whereas years and profit on y-axis and secondary y-axis respectively . I think it depends from scenario to scenario. please comment if i am wrong
@@chandoo_ thanks for clearing my doubt , i have one more query- I read in an article that using measures in secondary y-axis of area chart is not supported in POWER BI is not supported. Does this rule change acc. to scenario..?
Hi, I have situation where I need find the max value per row in power BI dax . Eg: Student | English |Spanish|French| A. 80 70 38 B. 50 49. 80 C. 79. 98. 60 Need to find the max score for each student. Could you please help.
Ticket Number Resolved Duration ([h]:mm) INC3726930 23:50 INC3728222 13:20 INC3731581 83:20 INC3734602 58:20 INC3736234 71:40 Please help create column chart based on above data Ticket Number >> X-axis Resolved Duration ([h]:mm) >> Y-axis I tried many ways to plot time in [h]:mm format on PBI but could not achive it, please help.
I am not sure if the "duration" formatting is allowed on Power BI visuals. Also, the minutes are coded with nn in Power BI DAX. You can do this: 1) make sure the resolved duration is converted to either duration or decimal value (with PQ or SQL) 2) then add the visual. The decimal value is shown on the chart and axis 3) Add labels with a custom label measure that generate the label text as per your data. Something like this: LBL = var s = sum('Table'[duration]) var hours = floor(s*24,1) var mins = FLOOR(MOD(s*24,1) * 60,1) return hours&":"&mins
sir whlie iam connecting mysql to power bi i got this error message An error happened while reading data from the provider: 'A call to SSPI failed, see inner exception.'" can plz help me to resolve my issue
Don't bother and exhaust yourself learning these cool Excel or other fancy IT software stuff if you want to get promoted or get high paid job. Develop your network and find a good buddy who has good connections, he/she will help you find a job in manager position. Then you will make your staff learn these tiresome & fancy Excel things and they will report to you 😁
I officially declare members of the Chandoo Fanclub are called 'Fan-doos'.
RUclips should find a way we can like a video more than once. because you deserve more than one like from me. Thank you sir
What a fantastic video! Your crisp and clear explanation turned something that takes years to understand into a 10-minute masterpiece. Truly unbelievable skills! As someone from Telugu land, I feel incredibly proud to see your brilliance shine on such a platform. Keep inspiring us with your incredible talent!
I am gonna show this video to all my friends trying PBI as i can not think of a clearer, more understandeable video for this topic. LOVE IT!
Thanks for the love @Balesz100
I really love these videos. They’re well done & a blessing for all who are trying to learn these skills. Thanks, Chandoo.
Such a wonderful video on Power BI chart types. Wish I had learnt power bi from your videos rather than trying to figure out naturally
Finally i was in a situation where i have to explore the other charts as well !
Great rundown, exactly what I needed, thanks!
Chandoo garu, Very clear, to the point, short videos- helping us a lot. Superb work.. Thanks for sharing such great videos
Thanks Chandoo, I just love your tutorial videos! 😉
Thanks for all the videos you put out, Chandoo!
i have never seen charts explained and presented as well as this..thank you chandoo.. very useful video.
Great and Informative Video i will share it to my friends
A great simple and clear overview of the chart types - much appreciated
Fantastic video explaining all the important charts that are most commonly used. Thankyou !!!
Glad it was helpful!
Got some clear concepts about using charts in Power BI. Nicely Explained.
Excellent and well presented, Thank you.
Great video!! Very well organized and presented!!
Very precise and informative..Thank u So much..
Amazing Video, cleared all my doubts!!
The way you explain... "How awesome is this..."
Thank you so so much sir ❤❤
thanks so much for this video, this helps me out to get a better understandig about the use of each charts.
Great job!!! You always make the videos I wish I had made.
Thanks for another great video, Chandoo!
Very helpful.
Really superb.. love this all your videos ❤
best and consice video 😘😘
New subscriber here!
Simply.....WooooW..
chandoo garu really appreciations for your great work.
i have a doubt ,if AI vaste power bi anedi vuntundha...
please answer cheyandi
Very useful, thanks
chandoo I am getting u well here in Africa
cool explanation 👍👌
Thumbnail is 💥💥
Fantastic ❤ thanks
Hi Chadoo, please do a video about water fall graphs
@3:49 i thought that x -axis has to be always to be a time based column but i worked on a datset in which i have to put countries in x-axis whereas years and profit on y-axis and secondary y-axis respectively . I think it depends from scenario to scenario.
please comment if i am wrong
As a rule use x axis for time. Flipped time axis is much harder to read in most situations
@@chandoo_ thanks for clearing my doubt , i have one more query- I read in an article that using measures in secondary y-axis of area chart is not supported in POWER BI is not supported. Does this rule change acc. to scenario..?
this is so nice Chandoo, how can I download the PBIX?
You can see the PBIX online and more here - chandoo.org/wp/powerbi-when-to-use-which-chart/
Hi, I have situation where I need find the max value per row in power BI dax . Eg:
Student | English |Spanish|French|
A. 80 70 38
B. 50 49. 80
C. 79. 98. 60
Need to find the max score for each student. Could you please help.
How to condition formats in 6:29 ?
Line and area chart to talk about trends
Ticket Number Resolved Duration ([h]:mm)
INC3726930 23:50
INC3728222 13:20
INC3731581 83:20
INC3734602 58:20
INC3736234 71:40
Please help create column chart based on above data
Ticket Number >> X-axis
Resolved Duration ([h]:mm) >> Y-axis
I tried many ways to plot time in [h]:mm format on PBI but could not achive it, please help.
I am not sure if the "duration" formatting is allowed on Power BI visuals. Also, the minutes are coded with nn in Power BI DAX.
You can do this:
1) make sure the resolved duration is converted to either duration or decimal value (with PQ or SQL)
2) then add the visual. The decimal value is shown on the chart and axis
3) Add labels with a custom label measure that generate the label text as per your data. Something like this:
LBL =
var s = sum('Table'[duration])
var hours = floor(s*24,1)
var mins = FLOOR(MOD(s*24,1) * 60,1)
return
hours&":"&mins
Hello @chandoo_ thank you, this workaround helps..🙏😊
How to add context in card visual
my data set is updated through gateway refresh but my visuals are not getting updated all this is happening in power bi service
sir whlie iam connecting mysql to power bi i got this error message An error happened while reading data from the provider: 'A call to SSPI failed, see inner exception.'" can plz help me to resolve my issue
Constatnt power BI video required sir. From early to the end. Please sir
Hi, i want to learn more on forecast.
Please make same for excel
Why vba not working in iMac
3
Don't bother and exhaust yourself learning these cool Excel or other fancy IT software stuff if you want to get promoted or get high paid job. Develop your network and find a good buddy who has good connections, he/she will help you find a job in manager position. Then you will make your staff learn these tiresome & fancy Excel things and they will report to you 😁