cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Slicer search for non text values

HI, hope someone can help on this.

 

I have a slicer filter on my report for a three of thousands of IDs. It would be great using search function (on the ellipses) but unfortunately only works with  values formated as text. I can not reformat my column due to access restrictions of the database, so thought it creating a duplicated column with a DAX formula that mirrors the original would do the trick. Due to same restrictions I can not simply add a column onto the database. Unfortunately my DAX knowledge is close to none. 

 

In essence, I am looking for a way to duplicate an entire column through a DAX formula so I can format as text this new column

 

Thanks in advance for the support

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Hi @iparras78 ,

 

Sorry for that it is a live connection mode.

So you cannot create a calculate column, you just can create a measure. But Power BI cannot support to put a measure in slicer.

 

Maybe you can create a new pbix file and use the import mode.

 

Slicer1.jpg

 

Or you can create a measure like this, and change the type to Text, then put it in Filter on this Visual.

 

TEXT = MAX('fact table'[index]) //you can change it to Table[ID]

 

slicer2.jpg

 

slicer3.jpg

 

If you have any question, please kindly ask here and we will try to resolve it.

 

Best regards,

 

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

7 REPLIES 7
Highlighted
Community Champion
Community Champion

@iparras78 

Hope you can add a new column in your  Power BI data model?.

Under Data View, Go to the particular table > New Column and add the following code to add a new column, Replace the name of the column [current Column] as necessary:, This will format it as text

New Column = FORMAT(Tickets[[Current Column],"@")

 

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

Highlighted
Super User IV
Super User IV

@iparras78 ,

refer if this can help

https://exceleratorbi.com.au/text-filtering-power-bi/

https://radacad.com/find-a-text-term-in-a-field-in-power-bi-using-dax-functions



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Highlighted
Community Support
Community Support

Hi @iparras78 ,

 

What data source do you use and what connection method do you use?

If it is import mode, you can create a calculate column to change the type, or you can change the type in Power Query Editor.

 

slicer1.jpg

 

If your connection is live connect, there is no way to change the type of this column.

You can process at the data source or you need to rebuild a new pbix file based on Import connection.

 

Best regards,

 

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Highlighted

@Fowmy thansk for taking the time to reply. Unfortunately accessing to inner data is restricted, hence the need for using dax formula to replicate the original column, see below snap showing we only have "Report" option

 

iparras78_0-1599549116125.png

 

Highlighted

@v-zhenbw-msft thanks for taking the time to respond. it is a live connection indeed and yes there is no possibility to change the format on the original column. That is why I thought a potential workaround would be duplicating that column through DAX formula and then formatting that new column once you have it in the "Fields" section.

 

I am not skilled in DAX so apologies if there is any misinterpretation on how it actually works on my explanations

 

regards, I

Highlighted

Hi @iparras78 ,

 

Sorry for that it is a live connection mode.

So you cannot create a calculate column, you just can create a measure. But Power BI cannot support to put a measure in slicer.

 

Maybe you can create a new pbix file and use the import mode.

 

Slicer1.jpg

 

Or you can create a measure like this, and change the type to Text, then put it in Filter on this Visual.

 

TEXT = MAX('fact table'[index]) //you can change it to Table[ID]

 

slicer2.jpg

 

slicer3.jpg

 

If you have any question, please kindly ask here and we will try to resolve it.

 

Best regards,

 

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted

There is a Visual named "Tile Search Slicer" . I think this will help you in getting what is required by you.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors