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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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