Adjusting the Dates to present in a Bar graph

[Luisaunor-0913]

Hi Guys

I have a Bar graph that presents like this basing on a Daily data 

Is there a way where it only presents 7 bars? When I use the slicer in this type of format

Right now it shows each day of the last 7 months

but what I only want to see is the 1st day of each month showing only 7 Bars.

Same concept as when I put the last 7 weeks

I only want to see 7 Bars containing the 1st day of the last 7 weeks.

What way to do this kind action?

[v-shex-msft]

Hi @Luisaunor-0913,

You can write a measure formula to extract the current date and compare with table date range to return tag, then you can use this on your chart 'visual level filter' to filter records based on tag condition.
If you are confused about coding formula, please share some dummy data to test.

How to Get Your Question Answered Quickly  

Regards,

Xiaoixin Sheng