Analyst in Action

If we talk about the level of detail then data labels can make your visuals stand out and add more context to them. There is a flip side too with them. The most common issue is when you put the data labels it creates a bit of a mess in your visuals and it becomes an intricate task if you consider the readability for the end users. That's not the objective of visualization. Let's consider a use case where we are creating a basic line graph with the evolution of discount percentages over a period. We are considering Sample Superstore data. Also, we have enabled the data labels for the whole series. You can play around with the formatting of your data labels. We can adjust the position, colors, and much more. If you focus on the title of the visual it's dynamic in nature and depends on the selection in the slicer. To know more about dynamic titles you can follow the link . From a visual point of view, the abovementioned visual is not so intuitive in nature.  To make it more in...

As Power BI users, we use titles for visuals or for pages. But what if I tell you to make the title of your visual more intuitive in nature. Is it possible? Yes, it is think of a scenario you have a slicer and a bar graph on a page. The management requested to make the title on the bar graph dynamic in nature. So let's dig deep into how can we build dynamic titles for your visuals. I am considering Sample Superstore data. The use case is to create a stacked column chart with a slicer of the city on the page. On the X axis, we are taking Category and Sub Category and on the Y axis, we are taking Sales amount. Now, if you see the title of the column chart it's static and doesn't change with the selection in the slicer. To make it dynamic in nature we will create a simple measure. Selected City = "Sales for " & SELECTEDVALUE ( SampleSuperstore [City] , "US" ) The DAX is quite simple in this case if we consider the selected value first we need to specify...