My requirement is i want to show the data Year and tertial wise by using slicer on my existingreport

[anjanikumar]

I have created the year table on my previous existing table( FY column) then created one custom colum " Time Granularity"(Tertial(Previous table) and Year(new table)) which will be created on both tables then will be appended both.

My requirement is i want to show the data Year and tertial wise by using slicer on my existing report but not filtering the data beacuse of previous filters or something else. 

I need help how to fix it ?

[v-pgoloju]

Hi @anjanikumar,

we kindly request you to share the sample data  in a workable format such as text, an Excel file, or a PBIX file with sample data instead of screenshots. Additionally, please include the expected output. This will enable us to assist you more effectively.

Regards,

Prasanna Kumar

[v-pgoloju]

Hi @anjanikumar,

 we kindly request you to share the sample data as suggested by @Greg_Deckler  in a workable format such as text, an Excel file, or a PBIX file with sample data instead of screenshots. Additionally, please include the expected output. This will enable us to assist you more effectively.

Regards,

Prasanna Kumar

[v-pgoloju]

Hi @anjanikumar,

Thank you for reaching out to the Microsoft Fabric Forum Community. And Thanks to @Greg_Deckler  for prompt and helpful response.

 we kindly request you to share the sample data as suggested by @Greg_Deckler  in a workable format such as text, an Excel file, or a PBIX file with sample data instead of screenshots. Additionally, please include the expected output. This will enable us to assist you more effectively.

Thanks & Regards,

Prasanna Kumar

[Greg_Deckler · Accepted solution]

@anjanikumar tertial: of, relating to, or constituting the flight feathers borne on the basal joint of a bird's wing

??

Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.