Want a custom LEGEND for your Power BI visual? WATCH THIS!

Поделиться
HTML-код
  • Опубликовано: 29 ноя 2024

Комментарии • 87

  • @spilledgraphics
    @spilledgraphics 4 года назад +10

    "It is the concept", nicely put Patrick! thanks for sharing this Legend Trick!

    • @GuyInACube
      @GuyInACube  4 года назад

      You are welcome. Thanks for watching! 👊

  • @arsemakedestyohannes
    @arsemakedestyohannes 2 года назад +2

    Thank you for your video, but I have a question how do you get the claim status color?

  • @kummithavenkatareddy2302
    @kummithavenkatareddy2302 Год назад

    Clustered Column Chart
    X-axis : A and B fields
    Y-axis: C field
    Legend: D field
    In D field i have 25 to 30 items ( like names, units, cities,... ). How to set up color for each item in the legend ( same color to be appear when we drill down/up based on A and B fields wise.

  • @helenawickstrom9181
    @helenawickstrom9181 4 года назад +3

    Hi, thanks for great video! I didn´t get how you created the Claim status that you put on the Axis, have you shown that in a previous video?

  • @kummithavenkatareddy2302
    @kummithavenkatareddy2302 2 года назад +1

    I want place legend Vertically like below at the bottom Center of any Visual
    Legends A B C D ( Horizontally )
    Legends A
    B
    C
    D. Is this possible in Power BI?

  • @letiziabellavia2488
    @letiziabellavia2488 2 года назад

    Hi, thanks for your video. I'd like to add a pop up window on the head of a column in order to describe the column content. I'd like to have a popup window for each column of my table.
    How can I do this? Thanks

  • @noelangesom9987
    @noelangesom9987 3 года назад +1

    How to add a legend for Matrix Visual where the fonts are conditionally formatted based on their values in a certain column?

  • @coder8515
    @coder8515 3 года назад

    Your videos put me out of troubles. Need to do simple a dashboard for a customer demo, but I'm a backend developer 😅 Until yesterday for me Power BI was an alien language. Thank you!

  • @letsstartlearning3960
    @letsstartlearning3960 4 года назад +1

    Hi team Its me tauseef could you please suggest is it possible to see data by using colour like if i click on red colour data should come which people which is not working

  • @oscardtrimboli
    @oscardtrimboli 2 года назад

    thank you for this video - my question is similar yet different - I need to color code the equivalent of your Top 5 Claims by Type - Passenger needs to be a different color to Property rather than all values being Blue - is that possible?

  • @ITyraxI
    @ITyraxI 4 года назад +1

    Hi. Please help. Can we do this on Pie or Donut charts?

  • @iiiiii-w8h
    @iiiiii-w8h 4 года назад +3

    Dude, you are the LEGEND.

  • @sahayanuj
    @sahayanuj 3 года назад

    Hi
    I have data of all the Nike locations of USA and locations of my warehouse. I wanted to plot all the locations on the map visual in power bi but i wanted the warehouse location bubble to be of 50 mile radius so I'll know how many Nike stores are within 50 miles of my Warehouse. Is there a way to change the bubble size of a particular legend??

  • @er3842
    @er3842 4 года назад

    Very Cool, I have a question outside this topic. How to connect MS Planner to be used in Power Bi? I've tried using FluentPro DataMart Cloud but it didn't work. I would like to have the tasks in MS Planner and see them in Power BI

  • @EngineeredFoodies
    @EngineeredFoodies 3 года назад

    Hi Patrick having the following issue while using legends in powerbi "repeated indices found in group by or projections". When there is no dimension in the axis pan, it goes fine. But when there is a dimension in the axis field it generates the above mentioned error.

  • @rosannerenzetti163
    @rosannerenzetti163 3 года назад

    THANKS!!!! Great solution to the limitations of legends in BI!

  • @Quadz2k
    @Quadz2k 4 года назад

    Good stuff, Patrick! I'm at the Houston PPWT and it took me a moment to realize it was you during the morning kickoff. I'll stop by to say hello.

  • @jonivanarsdale5126
    @jonivanarsdale5126 2 года назад

    Love this guy! Always makes everything look easy. Love that he left the Alexa/Siri snafu in there.. so funny.

  • @ryanjones7331
    @ryanjones7331 3 года назад

    Thank you for this video. Could you use this trick on a Stacked Column Bar Chart. I'm running the latest version of Power Bi but I do not have a fx option in the Data Colors section?

  • @dhawal28081991
    @dhawal28081991 4 года назад +2

    Hey Patrick,
    I think tree chart with labels is another effective way to do this.

    • @GuyInACube
      @GuyInACube  4 года назад

      Yup. Different ways to do it for sure! 👊

  • @linarayurash1453
    @linarayurash1453 2 года назад

    Hi Patrick, thanks a lot for this video! Can you please make a video about custom order of data legend?

  • @nelsonwongfaa5419
    @nelsonwongfaa5419 Год назад

    This is an awesome idea. 👍👍👍👍👍 Apply to your method, I used Treemap visual instead to have the same legend smaller and easier to adjust.

  • @naveens4793
    @naveens4793 4 года назад +2

    how did you do that client status color patrick

    • @mrhansros
      @mrhansros 3 года назад

      im wondering about this too.im stuck here

  • @krisliefeldt9318
    @krisliefeldt9318 4 года назад

    I love the idea - managed the conditional formatting in the table but my legend bars all have the same color although I followed the same steps - thoughts?

  • @RezaDorrani
    @RezaDorrani 4 года назад +1

    Brilliant idea !!!
    Loved the guest appearance from Alexa as well

  • @dkang2126
    @dkang2126 2 года назад

    Is there a way to make this custom legend smaller? I would like it to be the same size as the default legend (small circle, text, small circle, text, etc)

  • @nikhargesumit9069
    @nikhargesumit9069 4 года назад

    Hey Patrik.
    Could you help me with right way to calculate dynamic 12 weeks cumulative data ( i want to show last 12 weeks data in simple scorecard heading will have Week 1 , week 2, 3,4,5, etc and every week should have cumulative data week over week. from week 13 onward the range should be week 2 to week 13, from 14 the range should be week 3 to week 14, so on.)

  • @nathanphillips3628
    @nathanphillips3628 4 года назад

    Thanks for putting this together, and for responding to my comment on your earlier video about conditional formatting. Mind blown! Very creative use of a "standard" visual. Cheers.

  • @hosnaarabegum4429
    @hosnaarabegum4429 4 года назад

    Can you please help me out to understand this code ?
    I'm Unable to understand the SWITCH part specially.
    This code is intended for creating dynamic legend.
    Measure =
    VAR StateCount = CALCULATE(DISTINCTCOUNT(Bridge[State]), ALLSELECTED(Bridge), ALLSELECTED(Legend))
    VAR RegionCount = CALCULATE(DISTINCTCOUNT(Bridge[Region]), ALLSELECTED(Bridge), ALLSELECTED(Legend))
    VAR LevelNumber =
    SWITCH(
    TRUE(),
    StateCount = 1,
    3,
    RegionCount = 1,
    2, 1)
    RETURN CALCULATE(SUM(Fact[Population]), Legend[Level] = LevelNumber)

  • @MillyWally
    @MillyWally 2 года назад

    Awesome. I would love to have value, percentage and series name in the legend!

  • @DPFierce
    @DPFierce 4 года назад +1

    Awesome idea! Thinking outside of the box to re-purpose existing visuals to make something custom. Thanks for sharing!

    • @GuyInACube
      @GuyInACube  4 года назад

      Thanks for watching! 👊

  • @nptn17
    @nptn17 8 месяцев назад

    Mind-blowing. Thank you so much

  • @krynnadin
    @krynnadin 4 года назад

    Hey Patrick,
    Great Video, but my custom theme colors aren't coming through! I've defined them all in the theme as HEX colours, and now the Data Colors Formatting pane is throwing this error:
    "We found a value we don't recognize for Default Color."
    and the Default Color formula area is throwing this "help":
    "To fix the problem use HEX codes or use the supported list of CSS colors."
    I thought the theme WAS using HEX codes if I defined them in RGB / HEX in the theme JSON?

    • @krynnadin
      @krynnadin 4 года назад

      Nevermind, you created a column in the other video for the conditional formatting, and that's the column you used in your formula... Got it!
      Link to other video for posterity:
      ruclips.net/video/FgnPIaxpdJ0/видео.html

    • @krynnadin
      @krynnadin 4 года назад

      This actually spawns a new question. Can I access the Theme information from a DAX formula in order to create my colour column. Instead of in your example specifying "Red", "Green", "White", etc... I'd like to specify "Theme Colour 1", "Theme Colour 6", "Theme Colour 2", etc. in the dimension table that defines my legend colours.

  • @TheJacckson
    @TheJacckson 4 года назад +1

    Nice hack... Thanks guys. You guys are amazing, always !!

  • @arbazahmad7177
    @arbazahmad7177 Год назад

    Great Patrick... Thanks for sharing...

  • @sandymaverick4702
    @sandymaverick4702 4 года назад +1

    Holy moly.. You are amazing guys :) Love from India

    • @GuyInACube
      @GuyInACube  4 года назад +1

      Thank you for the kind words! 👊

  • @danneubauer6474
    @danneubauer6474 4 года назад

    Not what I was expecting at all, but a great method.
    Where can I get that shirt?!

  • @shrutiupari
    @shrutiupari 4 года назад

    Like ur videos, it really helps to understand the logic/calculations so easily.

  • @mariaivanova3683
    @mariaivanova3683 4 года назад

    Hi All, I couldn't understand the cal column "Claim status colour ", how he created it. Can someone help?

    • @GuyInACube
      @GuyInACube  4 года назад

      Are you looking for the actual DAX? or how to create a calculated column in general? docs.microsoft.com/power-bi/transform-model/desktop-tutorial-create-calculated-columns

  • @veronicazapotoczny7
    @veronicazapotoczny7 2 года назад

    Are you able to show a video on how to sort legends dynamically based on value, for a bar chart? Considering we have the axis as years, the values as budget, and the legend as 40+ categories, this seems to be a fairly complicated process and am wondering if there is a simple(r) way to achieve this. Thank you, love your videos!!!

  • @samgray559
    @samgray559 4 года назад +1

    Thats awesome! Thanks for sharing.

  • @kennethsmith9610
    @kennethsmith9610 3 года назад

    Thanks. Simple, SImple!

  • @melissahiggins4413
    @melissahiggins4413 4 года назад

    Thank you so much!!! This was a huge help because I was trying to figure out how to add this very setup to a graph. I am a new user and trying to do it without training! I definitely subscribed.

  • @michagicala132
    @michagicala132 4 года назад

    Great concept Patrick! Only thing I can say - it's bananas! Keep up great work Guys :)

  • @andreweverett
    @andreweverett 2 года назад

    Absolutely love your content. Thank you for this, I really needed it!

  • @salamalmosawi8730
    @salamalmosawi8730 4 года назад

    Love the concept, now i need to fit this into my reporting. From London, UK. Hope you guys are enjoying the Power Platform World Tour in Houston. Peace...

  • @nyanyaa8043
    @nyanyaa8043 3 года назад

    how can you create custom legend in a filled map?

  • @pratikfutane8131
    @pratikfutane8131 4 года назад +1

    Amazing concept 👌👌

  • @riazuddin7493
    @riazuddin7493 3 года назад

    How can I not show blank in my legend actually I created a table based on the data value like Resignation = volunteer and Retirement = Involunteer

  • @michaelyu8381
    @michaelyu8381 2 года назад

    Great job!

  • @SabariNathan-eh6iu
    @SabariNathan-eh6iu 3 года назад

    this legend applies for matrix chart???

  • @antique-bs8bb
    @antique-bs8bb 3 года назад

    Exactly what I wanted

    • @antique-bs8bb
      @antique-bs8bb 3 года назад

      Almost!. When I look at the tool tip for this I get the measure I used (you called yours legend) included as 1 for each colour/category.
      So maybe next time how do we remove lines from the simple tool tip? (or have you done that already).
      I hope it doesn't involve creating a whole page for the remote tool tip.

  • @dbszepesi
    @dbszepesi 4 года назад +1

    Nice, thanks!

  • @sumantramohan7887
    @sumantramohan7887 3 года назад

    can you hide legend label when no data exist in a chart in power bi

  • @muzahidali12
    @muzahidali12 4 года назад +4

    Legendary 😃

    • @GuyInACube
      @GuyInACube  4 года назад

      Thank you very much! 👊

  • @saadnageeb4633
    @saadnageeb4633 2 года назад

    Excellent

  • @vijaychowdary3965
    @vijaychowdary3965 4 года назад

    How to put multiple coloumns in one slicer.

  • @julsgranados6861
    @julsgranados6861 4 года назад +1

    Mmm maybe we can do the legend filters the visual , just thinking a loud

    • @GuyInACube
      @GuyInACube  4 года назад +1

      It's just a table, so it should work.

  • @NBAzzer
    @NBAzzer 4 года назад

    those squares were too big, dint met my requirements. ended up creating my own using shapes and textboxes :(

  • @gerryabramovich8739
    @gerryabramovich8739 3 года назад

    You great !

  • @jagadeeshmalleshappa7584
    @jagadeeshmalleshappa7584 4 года назад +1

    Wow!

  • @nancmadi
    @nancmadi Год назад

    LOL I just watched that video and thought the same thing...LOL

  • @ncbshiva
    @ncbshiva 4 года назад +1

    You are incredibly super

  • @yamc.19
    @yamc.19 4 года назад +1

    genius

    • @GuyInACube
      @GuyInACube  4 года назад

      Appreciate that! Thanks for watching 👊

  • @dddrrr7139
    @dddrrr7139 2 года назад

    this video should have all the steps, to be honest.

  • @davida.taylor8444
    @davida.taylor8444 2 года назад

    This is an ok solution for less complicated dashboards, but if I need to do this to every chart that I want to limit what gets listed in the legend...oi vey.

    • @GuyInACube
      @GuyInACube  2 года назад +1

      Of course. It always depends :)

  • @Jazz56974
    @Jazz56974 4 года назад

    Hacked