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
@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.
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'.
UA-cam should find a way we can like a video more than once. because you deserve more than one like from me. Thank you sir
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
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
I really love these videos. They’re well done & a blessing for all who are trying to learn these skills. Thanks, Chandoo.
Finally i was in a situation where i have to explore the other charts as well !
Chandoo garu, Very clear, to the point, short videos- helping us a lot. Superb work.. Thanks for sharing such great videos
Great rundown, exactly what I needed, thanks!
Thanks Chandoo, I just love your tutorial videos! 😉
A great simple and clear overview of the chart types - much appreciated
i have never seen charts explained and presented as well as this..thank you chandoo.. very useful video.
Got some clear concepts about using charts in Power BI. Nicely Explained.
Excellent and well presented, Thank you.
The way you explain... "How awesome is this..."
Thanks for all the videos you put out, Chandoo!
thanks so much for this video, this helps me out to get a better understandig about the use of each charts.
Great video!! Very well organized and presented!!
Great and Informative Video i will share it to my friends
Fantastic video explaining all the important charts that are most commonly used. Thankyou !!!
Glad it was helpful!
Very precise and informative..Thank u So much..
Amazing Video, cleared all my doubts!!
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..🙏😊
@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..?
best and consice video 😘😘
Thanks for another great video, Chandoo!
Great job!!! You always make the videos I wish I had made.
Really superb.. love this all your videos ❤
How to condition formats in 6:29 ?
chandoo garu really appreciations for your great work.
i have a doubt ,if AI vaste power bi anedi vuntundha...
please answer cheyandi
Hi Chadoo, please do a video about water fall graphs
chandoo I am getting u well here in Africa
New subscriber here!
Very helpful.
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/
Thumbnail is 💥💥
Very useful, thanks
Fantastic ❤ thanks
cool explanation 👍👌
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.
Simply.....WooooW..
Line and area chart to talk about trends
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
my data set is updated through gateway refresh but my visuals are not getting updated all this is happening in power bi service
Constatnt power BI video required sir. From early to the end. Please sir
Why vba not working in iMac
Hi, i want to learn more on forecast.
Please make same for excel
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 😁