cancel
Showing results for
Did you mean:
Regular Visitor

## Search first letter word from Slicers and display in card of previous edition

Hello All,

I would require your help on following criteria

1. i have a list of items in slicers (eg. Delhi 2018,Pune 2019,Delhi 2017,Pune 2017)

When i select Pune 2019 in slicer i should get the data of previous year data of Pune only, same with Delhi also. Need to show in Card.

1 ACCEPTED SOLUTION

Accepted Solutions
Super Contributor

## Re: Search first letter word from Slicers and display in card of previous edition

Hi @nagaraj007 ,

Suppose the fact data table is called 'Test_2', containing [Column1] and [Column2]. New a calculated table which is unrelated to 'Test_2', to list all available slicer items.

`Slicer table = VALUES(Test_2[Column1])`

```Measure 2 =
VAR yearNo_selected =
VALUE ( RIGHT ( SELECTEDVALUE ( 'Slicer table'[Column1] ), 4 ) )
VAR cate_selcted =
LEFT (
SELECTEDVALUE ( 'Slicer table'[Column1] ),
LEN ( SELECTEDVALUE ( 'Slicer table'[Column1] ) ) - 4
)
RETURN
CALCULATE (
SUM ( Test_2[Column2] ),
FILTER (
ALLSELECTED ( Test_2 ),
VALUE ( RIGHT ( Test_2[Column1], 4 ) ) = yearNo_selected - 1
&& LEFT ( Test_2[Column1], LEN ( Test_2[Column1] ) - 4 ) = cate_selcted
)
)```
Best regards,
Yuliana Gu
Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Super Contributor

## Re: Search first letter word from Slicers and display in card of previous edition

Hi @nagaraj007 ,

Suppose the fact data table is called 'Test_2', containing [Column1] and [Column2]. New a calculated table which is unrelated to 'Test_2', to list all available slicer items.

`Slicer table = VALUES(Test_2[Column1])`

```Measure 2 =
VAR yearNo_selected =
VALUE ( RIGHT ( SELECTEDVALUE ( 'Slicer table'[Column1] ), 4 ) )
VAR cate_selcted =
LEFT (
SELECTEDVALUE ( 'Slicer table'[Column1] ),
LEN ( SELECTEDVALUE ( 'Slicer table'[Column1] ) ) - 4
)
RETURN
CALCULATE (
SUM ( Test_2[Column2] ),
FILTER (
ALLSELECTED ( Test_2 ),
VALUE ( RIGHT ( Test_2[Column1], 4 ) ) = yearNo_selected - 1
&& LEFT ( Test_2[Column1], LEN ( Test_2[Column1] ) - 4 ) = cate_selcted
)
)```
Best regards,
Yuliana Gu
Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Regular Visitor

## Re: Search first letter word from Slicers and display in card of previous edition

Thank you Yuliana

Announcements

#### Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

#### Community News & Announcements

Get your latest community news and announcements.

#### Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Top Kudoed Authors
Users Online
Currently online: 39 members 2,269 guests
Recent signins: