Make an array of values and and use them in a slicer

[truttafisker]

Hi there

I don't have the values in tables which I want to use as possible options so I can present them in a slicer .. 
Therefor I thought of making an measure and present the values in the slicer which i then would use in another slicer ??

Is that possible .. 

I tried to make something like this .. where the "50000" should be based on a slicer/inputfield/or something third .. 

 

[v-kpoloju-msft]

Hi @truttafisker,

Thank you for reaching out to the Microsoft fabric community forum. Also, thanks @Rupak_bi,  for those valuable insights for this thread. As mentioned by @Rupak_bi, is correct. "Measure will not work in Slicer. It need table reference. you can create a manual table using "enter data" option in the ribbon with possible values and then use the calculation to filter the table and use it in a slicer."

After thoroughly reviewing the details you provided, I reproduced the scenario again, and it worked on my end. I used it as sample data and successfully implemented it.

outcome:

I am also including .pbix file for your better understanding, please have a look into it:

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you for using Microsoft Community Forum.

[truttafisker]

hi,
thx for your insight, but this can't/won't work when your datasource is a SASS .. unfortunately

[v-kpoloju-msft]

Hi @truttafisker,
Thank you for your follow-up and for clarifying that you are working with a SaaS-based data source.

You are correct certain techniques, such as dynamic tables, custom M code with parameters, or advanced DAX, may have limitations depending on the nature of the SaaS connector or restrictions imposed by the service.

To assist you further, could you please provide:

• The name of the SaaS connector/service you are using (e.g., Salesforce, Dynamics 365, etc.)
• A brief description of your objectives
• Any error messages or limitations you have encountered

With this information, I can suggest an alternate approach compatible with your data source.

Thank you for using the Microsoft Community Forum.

[truttafisker]

it's a system called timeextender/Jet

[v-kpoloju-msft · Accepted solution]

Hi @truttafisker,

Thank you for the clarification. The measure will not function in the slicer as it requires a table reference. You can create a manual table using the Enter Data option in the ribbon with possible values. Then, use the calculation to filter the table and apply it in the slicer.

Since you're working with TimeXtender/Jet, which abstracts the underlying data sources and often restricts dynamic query logic in Power BI, one practical approach is to pre-create or reshape the necessary tables or views within your TimeXtender model. This ensures Power BI receives the data in a compatible structure, especially when dynamic tables or parameters aren't supported.

If you can share more about your end goal (e.g., filtering, parameter-driven logic, etc.), We will be happy to assist. Let us know if you would like help with any of these steps or if you have any doubts feel free to reach out to us. 

Thank you for using the Microsoft Community Forum.

[Rupak_bi]

Hi @truttafisker ,

Measure will not work in Slicer. It need table referance. you can create a manual table using "enter data" option in the ribbon with possible values and then use the calculation to filter the table and use it in a slicer.