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)) )

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 😳

OMG you are brilliant!!! Thank you so much!!!

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.

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?

Can I get certificate after completing training

Hi Jenny, it looks like cloudscope now charge. Do you know a way to do without them? Thanks!

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

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

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.

Thanks for the video! Btw you have got a beautiful voice!

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?

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? 🤔

Hey! Could you share the code for the blank image?

Since I use a macbook, is it possible to do this project on Tableau? I heard the two are simlar

Thanks Jenny! Can you also give google drive link for this powerbi so that we can download and play with it?

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

Link plz

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

I'm a adviser I advise people to shut up and listen or else

That is great, thank you Jenny!

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.

Is data analyst job need to talk/meeting everyday?

Love this! been wanting to do this for ages, thank you!

Thank you 🥺

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?

It's very helpful thank you dear ,you so good 👍👍👍

Ouuw so this is the song you told me about it...I will downloaded on my phone

Outro song name?

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

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?

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?

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☹️.

Yep all necessary skills to succeed as a data analyst and have a career in data !

This was great. Thank you so much for walking through this.

Nice demo! Cool seeing the full array of the power platform

Keep it up

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?

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....

Thanks for this video, exactly what I needed!

You are a Goddess.

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.

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

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))))))))))

Great!

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 :)

Great video thanks a lot for the base 64 tip :) I was using unichar but the repressed designer in me was unsatisfied

Do you work for a agency?

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

Who else is listening to this masterpiece in May 2022