Thanks this has guided for my excel power pivot solution Dimenison Bin Slicer:=VAR SV = IF(HASONEVALUE(Table__DimensionBin[Month]), VALUES(Table__DimensionBin[Month])) RETURN SWITCH( TRUE(), IF(HASONEVALUE(Table__DimensionBin[Bin]), VALUES(Table__DimensionBin[Bin])) = "Month", CALCULATE([Measure Selection], FILTER(dim_Date, dim_Date[Month] = SV)), IF(HASONEVALUE(Table__DimensionBin[Bin]), VALUES(Table__DimensionBin[Bin])) = "Week of Year", CALCULATE([Measure Selection], FILTER(dim_Date, dim_Date[Week of Year] = SV)), IF(HASONEVALUE(Table__DimensionBin[Bin]), VALUES(Table__DimensionBin[Bin])) = "Quarter", CALCULATE([Measure Selection], FILTER(dim_Date, dim_Date[Quarter] = SV)) )
@digitaltwisted13462 ай бұрын
good video, but it needs to be mentioned that this cute little arrow will set you back $200/year if you want to publish your report 😳
@Mon-pd8os2 ай бұрын
OMG you are brilliant!!! Thank you so much!!!
@AkhilDuvvuru2 ай бұрын
Hey @Jenny - Thanks so much. This really helps. I have a similar requirement where I have customer slicer with 10 customers and based on my selection I should be able to trigger the Power Automate flow which should export the Power BI Report with that filter applied as PDF. If I select 1 customer, then it should export 1 PDF file, if I select 3 or 4 customers in the slicer, then the Power Automate should run in a loop and export (send an email) with 4 PDF attachments (1 per each customer). Can you help me with the same, especially the looping part? Thanks in advance.
@JuanAscencio-ug5ly3 ай бұрын
Hi... Very nice and motivating video!!! I am in the Bay Area and would like to study something on data analytics. I am already playing with Power BI empirically, but would like to have a more structure guidance. What would you recommend? Actually, do you provide any service like it?
@poojarya3823 ай бұрын
Can I get certificate after completing training
@gp39037 ай бұрын
Hi Jenny, it looks like cloudscope now charge. Do you know a way to do without them? Thanks!
@stefankleinhans48957 ай бұрын
Hi, Is it possible to have a 1 slicer change the Matrix Table rows, columns and value respectively for example Slicer has two selections A and B When I select A on the slicer the Matrix table Row shows a list of cars and the purchase Cost in the values and the 5 countries in the columns header When I select B on the slicer the Matrix table Row shows the 5 counties and the list of cars in the column header and the selling price in the value Is this possible and how do I do it
@ibrahimabubakar5618 ай бұрын
this is absolutely amazing thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you thank you
@user-ym2dm6nx1h10 ай бұрын
I found it's easier (but not as custom) to just use wingdings font, then windows character map to figure out what character needs to be used in PowerBI with wingdings to get the icon result you are looking for.
@jennytumay10 ай бұрын
thank you for sharing :)
@ayushkar222610 ай бұрын
Thanks for the video! Btw you have got a beautiful voice!
@PaulinaKasprzak Жыл бұрын
Great video but for some reason it only works for me in PowerBi Desktop. When I actually publish it in PowerBi web app, I get an image URL related error. Does it work fine for you when publishing?
@user-ml7hy6po4p Жыл бұрын
Hey, thanks a lot! 😄 Quick question: Can I extract an Excel or CSV file from Power BI using a Power Automate based on the power BI filter, and then send this file over email as an attachment? Like, let's say I've got Customers A, B, and C, and I want to send them their related Performance data in Excel every month. So, I pick Customer A in Power BI Slicer or filter, trigger the flow, and bam! Customer A gets that email. (other option is to select Customer A and B in power BI but every one receive separate email with different dataset) Can you please describe or make a vedio about how this whole process / Flow would work? 🤔
@brunof.s.8186 Жыл бұрын
Hey! Could you share the code for the blank image?
@andrewchen2590 Жыл бұрын
Since I use a macbook, is it possible to do this project on Tableau? I heard the two are simlar
@jennytumay Жыл бұрын
hmm im not sure I haven't used tableau, but this is a fairly basic project so I would think you would be able to do something similar!
@faridaakbarli Жыл бұрын
Thanks Jenny! Can you also give google drive link for this powerbi so that we can download and play with it?
@alexanderrubanenko3697 Жыл бұрын
Thanks for the video, because I have quite large data, the 'Apply to each' is going through each row instead of the looping the distinct values only....I wonder if there is a way to by pass this
@rajkumarbablu3706 Жыл бұрын
Link plz
@muhammadluqmanulhakim528 Жыл бұрын
great video! But, i actually focusing more on your "Movie List" Visual, How can you create that? All this time, I only create a list that can be scrolled up n down using table
@jennytumay Жыл бұрын
it's a matrix visual with stepped layout +/- icons!
@brianjohnson-wl6qq Жыл бұрын
I'm a adviser I advise people to shut up and listen or else
@gemmafornes Жыл бұрын
That is great, thank you Jenny!
@hbf0 Жыл бұрын
Hi Jenny, great video. Quick question, could you please show me the %Change formula? When I try to add the arrow formula, it tells me that there is a calculation error in measure 'Total Requests' (which is the equivalent to your %Chage): The function SUM cannot work with values of type String. Thank you.
@jennytumay Жыл бұрын
hi GFT make sure with SUM you are aggregating against a number column not a string column! check your data type
@91lovemusic Жыл бұрын
Is data analyst job need to talk/meeting everyday?
@jennytumay Жыл бұрын
almost every day i have at least one meeting!
@jorgearganaraz5909 Жыл бұрын
Love this! been wanting to do this for ages, thank you!
@jennytumay Жыл бұрын
yay! glad you found it helpful
@meher7 Жыл бұрын
Thank you 🥺
@jennytumay Жыл бұрын
your're welcome :)
@RKB_1 Жыл бұрын
Great instructions. I wanted to use power automate for multiple slicer selections which are applied on a calculated table in PBI. Goal is to generate a table of already defined measures (of calculated table) based on slicer selection. Is your method applicable for calculated table in PBI?
@jennytumay Жыл бұрын
Hi rohan! Are you asking if we can reference calculated tables in the power automate visual? My answer to that would be i believe yes. And my answer to if we wanted to have multiple power automate inputs with different slicer selections would also be yes!
@anuragnaik33885 ай бұрын
@@jennytumay Hi Jenny, Can i ask you how to add multiple slicers as input to power automate
@dasarirajendra7988 Жыл бұрын
It's very helpful thank you dear ,you so good 👍👍👍
@jennytumay Жыл бұрын
You’re welcome!!
@okbye8128 Жыл бұрын
Ouuw so this is the song you told me about it...I will downloaded on my phone
@okbye8128 Жыл бұрын
Outro song name?
@jennytumay Жыл бұрын
the data analytics song! It's one of my videos :)
@okbye8128 Жыл бұрын
@@jennytumay thank you i hope one day i became a data analytics like you..but its hard to explain my situation 😂 thanks Again for the song and good luck in your career
@jennytumay Жыл бұрын
@@okbye8128 you can do it!! :D and thank you im so glad you enjoyed!!
@Broadb1ll Жыл бұрын
This is great Jenny, thanks. I've got it work, but the top and bottom of my arrow is getting cut off. Is this down to the export from powerpoint and the pixels? I know you mentioned 5x5 pixels? how do you tell the powerpoint export to create 5x5? Thanks
@jennytumay Жыл бұрын
Hmm it could be! You can change shape size in powerpoint by right clicking on your shape -> format shape -> size -> type in 5 px or however many pixels you want in the height and width parameters (It will convert the pixel input back into inches)
@pearlking Жыл бұрын
This works well for other visuals but in matrix it doesn't generating the row wise total....is there any other way around to solve the issue?
@jennytumay Жыл бұрын
Hi muthu, i added steps for calculating the total in the description box!
@pearlking Жыл бұрын
@@jennytumay Thanks for your swift response. I'll try to work those steps & let you know.
@pearlking Жыл бұрын
@@jennytumay Thank you very much Jenny...The DAX given in the description works great!
@Invoeren Жыл бұрын
At 2:31 I have to add the compose step to the Append flow but I don't have that option. My only options are the variable that I inserted in the Initialize step or Current item. Can you help me?
@jennytumay Жыл бұрын
Hi michael did you make sure your compose was inside the apply to each step?!
@darray7472 Жыл бұрын
You sound like you are back to being your normal chipper self! I thought your poetry vlog was brilliant but I sensed some sadness in it☹️.
@jennytumay Жыл бұрын
hi :) yes i am and yes there definitely was. I noticed that after I rewatched it how much it came across
@darray7472 Жыл бұрын
Glad things are better! Thanks for all you do - you are making a difference😇
@nicky_rads Жыл бұрын
Yep all necessary skills to succeed as a data analyst and have a career in data !
@jennytumay Жыл бұрын
🥹
@ashleyrp2007 Жыл бұрын
This was great. Thank you so much for walking through this.
@jennytumay Жыл бұрын
you're very welcome im glad it was helpful! :)
@nicky_rads Жыл бұрын
Nice demo! Cool seeing the full array of the power platform
@jennytumay Жыл бұрын
Thank you nick!!
@Ravi-ek9ct Жыл бұрын
Keep it up
@jennytumay Жыл бұрын
☺️
@ravi4872 жыл бұрын
Hi, great video! When I added my arrow using the "Clouscope Visual" am unable to move it by dragging. Any thoughts what I could be doing wrong?
@jennytumay2 жыл бұрын
hi thank you :) the visual is super hard to move i faced that same problem. i would recommend using size and position properties on the visualization pane of the visual
@ravi4872 жыл бұрын
@@jennytumay Hi thanks for the response. Just as a FYI for everyone, you can actually move the arrow by clicking on the three dot menu at top right of image, holding it down, and moving jt to your desired location
@jennytumay2 жыл бұрын
@@ravi487 🤯😁
@Maldive1772 жыл бұрын
you are probably well educated, or your family provided you good education source, you used it well, good for you. I've growed up in a very poor family, did not have the chance and money to go to university... although I really wanted to...:) I wish i could live the nice apartment that you have there, even just for one night.... but anyway, good to watch your video....
@dandylion162 жыл бұрын
Thanks for this video, exactly what I needed!
@justlearnitquick2 жыл бұрын
You are a Goddess.
@smsohelozzaman30262 жыл бұрын
I liked your comment on SWITCH that it is a glorified IF statement. On the other day, I was telling the same to one of my colleague and he was angry with me ;). He thought he was coding by just making one switch statement in Power BI.
@jennytumay2 жыл бұрын
😂
@shivangdubey24942 жыл бұрын
This is the error I am facing Too many arguments were passed to the selected value function. The maximum argument count for the function is 2
@shivangdubey24942 жыл бұрын
Hi Jenny, Please help me with this calculation what's wrong with the below calculation, Count Dimension Slicer = VAR SV = SELECTEDVALUE('Dimension Slicer'[Entity]) RETURN SWITCH(TRUE(), SELECTEDVALUE('Dimension Slicer'[Dimension] = "Business Unit",CALCULATE(COUNT(Data[Business Unit]),FILTER(Data,Data[Business Unit] = SV)), SELECTEDVALUE('Dimension Slicer'[Dimension] = "Database",CALCULATE(COUNT(Data[Database]),FILTER(Data,Data[Database] = SV)), SELECTEDVALUE('Dimension Slicer'[Dimension] = "Therapeutic Area",CALCULATE(COUNT(Data[Therapeutic area]),FILTER(Data,Data[Therapeutic area] = SV)), SELECTEDVALUE('Dimension Slicer'[Dimension] = "Statistician",CALCULATE(COUNT(Data[Statistician]),FILTER(Data,Data[Statistician] = SV)), SELECTEDVALUE('Dimension Slicer'[Dimension] = "Study Lead",CALCULATE(COUNT(Data[Study Lead]),FILTER(Data,Data[Study Lead] = SV)), SELECTEDVALUE('Dimension Slicer'[Dimension] = "Status",CALCULATE(COUNT(Data[Status]),FILTER(Data,Data[Status] = SV)), SELECTEDVALUE('Dimension Slicer'[Dimension] = "Quarter",CALCULATE(COUNT(Data[Quarter Started]),FILTER(Data,Data[Quarter Started] = SV))))))))))
@ERPCoder2 жыл бұрын
Great!
@jennytumay2 жыл бұрын
guys!! as much as it pains me to say that microsoft power bi has outdone me, microsoft power bi has outdone me, with a new preview feature called field parameters. It's basically what i'm doing here but in a less "hacky" way since it's giving power bi the innate ability to do dynamic columns with slicer selection. go check it out :)
Hi Jenny. I just want you to know that this version saved me from redoing my report. The version of some pbi (reporting server version) does not have the parameter. I want to thank you for this Just created this account to comment and subscribe to you! xoxo
@jennytumay Жыл бұрын
@@ririb6502 omg yay!! thank you riri im so glad 🙏🥰
@TheImac1616 Жыл бұрын
Can you make a new video?
@jennytumay Жыл бұрын
@@TheImac1616 do you have any requests?!!!
@quentinmartiny16152 жыл бұрын
Great video thanks a lot for the base 64 tip :) I was using unichar but the repressed designer in me was unsatisfied
@jennytumay2 жыл бұрын
Yay you’re welcome! We love base64
@CaribouDataScience2 жыл бұрын
Do you work for a agency?
@jennytumay2 жыл бұрын
Consulting firm! :)
@lukass11572 жыл бұрын
Hi, I have got 10 years of BI experience developing mostly in Tableau, Qlik and Spotfire, now learning Power BI. I am quite positive I would not be able to so clearly and smoothly transfer my knowledge to someone else. I am really impressed and intimidated I have to compete with such an impressive developer :) ! Also, really enjoy seeing your sample project choices... Taylor Swift prequeled by Star Wars... :D Way to go, just please dont get way too good ! (or at least be expensive so there is some job left for the elderly) :D
@jennytumay2 жыл бұрын
🥺🥺 thank you for the kind comments seriously so sweet and stoked u enjoyed those vids!!
@muzammilkhan022 жыл бұрын
Who else is listening to this masterpiece in May 2022