PowerBI Legends through formatted text

PowerBI Legends through formatted text

Text is the most under utilized tool in visuals. Few days ago I saw a post by Christopher Chin where is showed a unique way to show legend in a visual, and I was trying to figure out how to recreate it in PowerBI such that it is dynamic(change with filter) and show different color is a single text. The cool part is, you don't even require to write DAX for it.

This was the post by him which you can read from here :

So to create this, you use textbox. Yea! textbox. It is so much more uselful than I though.

In the textbox, you select particular text and change its formating which for only the required text, unlike text inside the shape, or in a visual, where formating is the same for the whole text string.

However, the real thing is how to add measures to it. Actually it is very easy.

There is an option +value, click on it and it will open a panel, here you can type what calculation you want. In this example, I have a measure called profit, and I want profit for audio and video, as I type it, power bi will give me suggestion which you can select and check the value

No alt text provided for this image
No alt text provided for this image

Select the calculation you want, give it a name and format its type. You can create multiple values and save them, which then can be view and added as text from review. The values are interactive, which means it changes with filter. Moreover, it doesn't have to be numbers, you can add text based on selection as well, such as month, year, name etc.

No alt text provided for this image

In the end, you can place the curser and click + to add the value in that part of the text, which you can format according to your need.

Moreover, the text would have an underline(hyperlink), which shows that this text is a value and when you click on it, it will take you to the edit part of that calculation, but it is not shown in the published report, only in edit view.

And that's it. There is so much room to use this trick, especially as formated string as a tool tip, since tool tip shows only one selection, so for instance you can use product name, and when you hover over a certain product, it will show its name and value only

Excellent! That is good storytelling!

Jeroen Heerschop

Leer Power BI met Power Up

2 年

Thanks Syed Ahmed Ali . How did you color the font for the measure values?

回复
Tristan Mobbs

Data Translator, giving data meaning. Ensuring analytics delivers business results. Podcast Speaker.

2 年

Nice formatting Syed Ahmed Ali, I definitely think this is a great replacement for a legend. It also tells you all the information you need without the doughnut.

Interesting and potentially useful. I either case, you are making the viewer "work" They see yellow or green and then need to adjust their gaze to decode. Why not just label the slices? At the same time, you can add a Tooltip which includes additional information in context where it counts. By its very nature, a Donut Chart is not intended to provide great detail at first glance. Magnitude is obvious, A/V is twice that of Appliances. I'm not sure additional header text adds any value.

  • 该图片无替代文字
Gagan deep Singh

SQL ,Power BI, Advance Excel

2 年

Awesome Syed I really like the tricks you find it ...

要查看或添加评论,请登录

Syed Ahmed Ali ???? ????的更多文章

  • Power BI Dynamic Top N (Include Others) using Parameter

    Power BI Dynamic Top N (Include Others) using Parameter

    A few months ago, I worked with a client who had a unique requirement: they needed a filter that could dynamically…

    10 条评论
  • A Comprehensive Guide to Power BI Error Bars

    A Comprehensive Guide to Power BI Error Bars

    Introduction Error bars are essential for visualizing data variability and uncertainty, making them invaluable for more…

    5 条评论
  • Mastering Power BI DAX: IsInScope

    Mastering Power BI DAX: IsInScope

    When working with hierarchies in Power BI, managing totals and granular levels can be challenging. One function that…

    7 条评论
  • Power BI: Highlighting Selected Items

    Power BI: Highlighting Selected Items

    Highlighting specific items in Power BI is a powerful way to enhance data analysis, especially when comparing these…

  • Power BI Dynamic Formatting Trick

    Power BI Dynamic Formatting Trick

    Sharing a cool trick I have been using for dynamic formatting in Power BI which I don't see many people use, and it is…

  • Power BI Custom Label Trick (Dynamic Selection)

    Power BI Custom Label Trick (Dynamic Selection)

    In the realm of data visualization, the utilization of custom labels has unlocked a myriad of possibilities. However, a…

  • Power BI Dynamic Icon Image based on condition (New Card Visual)

    Power BI Dynamic Icon Image based on condition (New Card Visual)

    Did you know you can dynamically show images based on the numerical values with the new card visual. Created this whole…

    7 条评论
  • Distribution Chart Power BI with Gradient Color Using Dax

    Distribution Chart Power BI with Gradient Color Using Dax

    This is simply the combination of Matrix and Scatter plot in Power BI. Problem To create this scatter plot, need…

    2 条评论
  • Power BI Highlighted line based on selection

    Power BI Highlighted line based on selection

    Colors are a powerful tool in visual communication, but too much of a good thing can be overwhelming. This is…

    6 条评论
  • PowerBI Left-Anti Join using DAX(Dynamic)

    PowerBI Left-Anti Join using DAX(Dynamic)

    You can directly use left-anti join in power query, but it won't change with selection on filter. I came across a…

社区洞察

其他会员也浏览了