Forum Discussion

Johnsmith23's avatar
Johnsmith23
Frequent Visitor
3 years ago

Display only first mid and end data label

Hello all

  • I have Clustered bar chart where I'll displaying Fiscal Year, Fiscal Quarter, Fiscal month I wanna show Only first, Mid and last data label According to the slicer Selection
  • Example: If Slicer has selected year from 2015 to 2021. Data label should be visible only for the year 2015, 2018, 2021 I should be applicable also for the month and Quarter as well. Is this Possible?
  • Thanks in advance!!

 

  

Need Help
Tips and Tricks

1 Reply

  • Tlotly's avatar
    Tlotly
    Icon for Helper V rankHelper V
    3 years ago

    Hi Johnsmith23 

     

    This one is tricky. If you can create 3 new measures i.e. One that calculate Income for min(year), one for max(year) etc... Then plot those measures in your chart and change it into a stacked column chart. (Dont remove your current measures). Your new measures will be on top. Then on colors, change the bar color of your new measures to white. On Data labels, turn the labels for your existing measure off and On for the new measures. You can then play around with the position, but the Inside end will be the most proper for the display. 

     

    Hope this gives some light. Thanks

     

    edit: below is the link to an example I made. I only created max date variable: For minimun date measure, replace maxx with minx etc...

    https://www.dropbox.com/s/pwbjuk80yc7urmj/TestLabels.pbix?dl=0