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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
jmiridium
Helper IV
Helper IV

Show Reults of Only Part Of a Row

So I have a result coming in a column that shows the whole version, build, copyright info of the server I am querying. I would like to make seperate cards that split up the result, such as Server Version in one card, build in another, and completely drop copyright information. How do I filter the text results?

1 ACCEPTED SOLUTION

Hi @jmiridium,

Firstly, in Query Editor, split column as shown in the following screenshot.
1.PNG

Secondly, remove unused columns in Query Editor.
2.PNG

Thirdly, in Report View, create the following columns in your table.

FirstCol = LEFT(Table2[Column1.1],FIND("-",Table2[Column1.1])-1)
SecondCol = REPLACE(Table2[Column1.1],1,FIND("-",Table2[Column1.1]),"")
ThirdCol = LEFT(Table2[Column1.4],FIND(")",Table2[Column1.4]))
3.PNG

Regards,
Lydia Zhang

Community Support Team _ Lydia Zhang
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

You need to either:

 

A) Create a calculated column(s) in query editor to grab the text you need

B) Split the column by delimeter (space?) and then combine the columns you need

C) Use DAX to create a few measures that grab the text you need

 

The best approach is likely C, and will be the pattern of calculating the length of the whole string and finding the location of an appropriate substring or character and then grabbing the text.

 

Pseudo code =

 

LEFT(Text,LENGTH(Text)-FIND(Substring))

 

So in this case this is the result unfiltered:

 

Microsoft SQL Server 2012 - 11.0.5058.0 (X64)
    May 14 2014 18:34:29
    Copyright (c) Microsoft Corporation
    Enterprise Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: ) (Hypervisor)

 

I would like to create three new cards, one showing "Microsoft SQL Server 2012", one showing "Build: 11.0.5058.0 (X64) " and the third showing "Enterprise Edition (64-bit)"

Is this all inside one cell, or multiple rows in the column?

Inside one cell

Hi @jmiridium,

Firstly, in Query Editor, split column as shown in the following screenshot.
1.PNG

Secondly, remove unused columns in Query Editor.
2.PNG

Thirdly, in Report View, create the following columns in your table.

FirstCol = LEFT(Table2[Column1.1],FIND("-",Table2[Column1.1])-1)
SecondCol = REPLACE(Table2[Column1.1],1,FIND("-",Table2[Column1.1]),"")
ThirdCol = LEFT(Table2[Column1.4],FIND(")",Table2[Column1.4]))
3.PNG

Regards,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Actually I figured out what was in the screen shot. Thank you so much!

Got the following error:

 

splitcolumn.JPG

 

What is the special character to split by?

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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