Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Create a subset of a table

Hi,

I have the following tabular information:

 

account_codenameeffective_frommonth_effective_fromYear_effective_fromMonth-Year-effective_fromeffective_tomonth_effective_toYear_effective_toaccount_type_code
OG001Oil & Gas2017-07-14 07:41:06.7247227 +00:00717Jul-172018-10-26 10:43:16.6078098 +10:30October2018mining
BNK001Banking2017-07-14 07:41:06.7247227 +00:00717Jul-172018-10-26 10:43:16.6078098 +10:30October2018Finance
EDU001University2017-07-14 07:41:06.7247227 +00:00717Jul-172018-10-26 10:43:16.6078098 +10:30October2018Education
TEC001Technoogy2017-07-14 07:41:06.7247227 +00:00717Jul-172018-10-26 10:43:16.6078098 +10:30October2018IT
OG001Oil & Gas (Asia)2018-10-26 10:43:16.6546562 +10:301018Oct-182019-06-06 15:53:16.1318654 +09:30June2019mining
BNK001Banking (Asia Pacific)2018-10-26 10:43:16.6546562 +10:301018Oct-182019-05-19 16:33:17.1352558 +09:30May2019Finance
EDU001University (Oceania)2018-10-26 10:43:16.6546562 +10:301018Oct-182019-05-19 16:33:17.1352558 +09:30May2019Education
TEC001Technoogy (Worldwide)2018-10-26 10:43:16.6546562 +10:301018Oct-182019-05-19 16:33:17.1352558 +09:30May2019IT
OG001Oil & Gas (Asia)2019-06-06 15:53:16.1318654 +09:30619Jun-19   mining
BNK001Banking (Asia Pacific)2019-05-19 16:33:17.1352558 +09:30519Jun-19   Finance
EDU001University (Oceania)2019-05-19 16:33:17.1352558 +09:30519Jun-192019-07-20 02:35:21.7312951 +09:30July2019Education
TEC001Technoogy (Worldwide)2019-05-19 16:33:17.1352558 +09:30519Jun-19   IT

MED001

Hospital2020-07-20 02:35:21.7312951 +09:30720

Jul-20

 

   

 

 

 

 In PBI, I have a drop down filter for Month-Year-effective from. Based on what user chooses using the drop down, I need to create a subset table with all effective_from and effective_to.

 

I tried useing the FILTER function, but selectedVALUE(Mnonth-Year-effective_from) doesnt give me the selected value, instead it displays blank. Is this the correct way of doing?

1 ACCEPTED SOLUTION
TheoC
Super User
Super User

Hi @Anonymous 

 

Are you trying to create a new "table" or are you trying to filter the existing table?

 

If it is just to filter the table based on a Slicer visual, you can drag the "Month-Year-effective_from" field into the Slicer visual and the user can simply select the Month Year such as that below. If it is not what you were after, it would be good to get some further clarification on your need if that's okay?

 

TheoC_0-1634090061982.png

TheoC_1-1634090116534.png

Thanks,
Theo 🙂

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias

View solution in original post

1 REPLY 1
TheoC
Super User
Super User

Hi @Anonymous 

 

Are you trying to create a new "table" or are you trying to filter the existing table?

 

If it is just to filter the table based on a Slicer visual, you can drag the "Month-Year-effective_from" field into the Slicer visual and the user can simply select the Month Year such as that below. If it is not what you were after, it would be good to get some further clarification on your need if that's okay?

 

TheoC_0-1634090061982.png

TheoC_1-1634090116534.png

Thanks,
Theo 🙂

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.