Пікірлер
@tarunikaumashankar3644
@tarunikaumashankar3644 Ай бұрын
Hi, great video! But the JSON file is not available for download. Where can I find it? I am not able to find the images as well. Those are not available for download.
@thulasiram9664
@thulasiram9664 Ай бұрын
Yes there is nothing told about the "Value" in INFOME table
@kajola
@kajola 4 ай бұрын
Exactly what I was looking for, thanks
@surbhikshah2423
@surbhikshah2423 5 ай бұрын
isn’t there way to add 0 by default if it is blank This is great but it works only if you want null
@user-hk7qv4wy5w
@user-hk7qv4wy5w 9 ай бұрын
Hi is there way to change the (blank) to a hyphen?
@annieliu41
@annieliu41 10 ай бұрын
thank you!! Help so much
@user-uc9eu8ic2p
@user-uc9eu8ic2p 11 ай бұрын
Perfect! Thanks
@rhymingname
@rhymingname Жыл бұрын
I have been looking for an answer to this for days! Thank you so much!
@inturns_with_interns5768
@inturns_with_interns5768 Жыл бұрын
Thank you so very much. I was struggling to hide this by creating measures and couldn't think of this easy solution.
@alicedwonderland7733
@alicedwonderland7733 Жыл бұрын
a neat trick! Thank you!
@jason7761
@jason7761 Жыл бұрын
Awesome, saved me a lot of head scratching!
@user-ru1ij1qq3w
@user-ru1ij1qq3w Жыл бұрын
Thank you. You saved my day
@jakubpospieszynski9222
@jakubpospieszynski9222 Жыл бұрын
You can make it better without adding double cards. You can basicly make VAR with value and VAR with emoji. In RESULT just add VALUE && EMOJI and then you have it.
@BBJN27
@BBJN27 Жыл бұрын
Hi i'm bird from thailand Thank you very much for this knowledge. It can help me accomplish one more task. ❤
@farhanasacha970
@farhanasacha970 Жыл бұрын
Hi Bianca - thank you for your video - so I tried to do this and all is fine, until I start utilising the slicer to break actuals and targets down by per month and the numbers dont dynamically update....is there an additional step I would need to take?
@ahadthetraveler
@ahadthetraveler Жыл бұрын
Please make more dashboards. Looking forward thanks.
@LCDRmikecorrigan
@LCDRmikecorrigan Жыл бұрын
Awesome! You rock! Can you do this with Text also?
@assistejantandoai1613
@assistejantandoai1613 Жыл бұрын
Can you please explain Why do you use { and two dots ".."?
@mrsmelaniecook
@mrsmelaniecook Жыл бұрын
So clear and kind. Thank you!
@abbasthegreat5
@abbasthegreat5 Жыл бұрын
ColumnName = COUNT('Table'[Id])+0 More better solution instead of changing backgroud
@tahiking-hazel603
@tahiking-hazel603 Жыл бұрын
nice - better than other ways I've done it, ie card covering then . . . . . . ..😴 this is fast and simple. More tips and tricks please
@mykod9651
@mykod9651 Жыл бұрын
I think video skips some details around the step where you unpivot the years 16:53
@user-7.7hmood
@user-7.7hmood Жыл бұрын
Can you provide excel files so we can work with you?
@kieranthomson1424
@kieranthomson1424 Жыл бұрын
There is no ASX in the download??
@biancagilly
@biancagilly Жыл бұрын
Hi Kieran, the ASX data is called from a website. To call the data, download the text file, open Power Query, Create a Blank Query, Click Advanced Editor, Paste notepad content. ASX Text File: biancagilly.com/wp-content/uploads/ASX.txt
@catherinetaylor4278
@catherinetaylor4278 Жыл бұрын
thank you so much for this, took me ages to find the ideal solution, you are a life saver!
@TheLonelyViper
@TheLonelyViper Жыл бұрын
Thank you!
@thanzeemrahman2067
@thanzeemrahman2067 Жыл бұрын
Hi, can you instruct on how we can break down annual target for a year without dates can be broken down to daily targets? and assign dates for each of those daily targets
@ProfDreco
@ProfDreco Жыл бұрын
Excellent tip!
@Marina-mj6wu
@Marina-mj6wu Жыл бұрын
very well explained - thank you!
@Marina-mj6wu
@Marina-mj6wu Жыл бұрын
I always wondered how to rename avalue when it shows up with the prefix "First" - so I'm really pleased to have learnt the trick to rename it on a visual!
@ruudvd5955
@ruudvd5955 Жыл бұрын
Perfect solution, Thanks!
@Agcz1213
@Agcz1213 2 жыл бұрын
or we can create a dummy measure and add + 0 at the end, so it will display as zero and doesn't affect our calculations as well
2 жыл бұрын
What if instead of filter the values from a slicer I select a record directly from the Table? Is it possible to build something similar but by selecting one record from the Table?
@nikkiclayton7581
@nikkiclayton7581 2 жыл бұрын
Such an easy solution, thank you!
@ChrisMMeehan
@ChrisMMeehan 2 жыл бұрын
Love, love love this! It is by far is the easiest smartest solution to this common problem. So many videos and forums, suggest writing new measures for this exact problem.
@JumpUpJumpUpandPowerPlatform
@JumpUpJumpUpandPowerPlatform 2 жыл бұрын
Real clev. love it.