Previous value + blank along with Slicer selection should be displayed

[Vannikannan]

Hi All,

I have an requirement as shown below:

The below is the records available in the grid.If I select KLS-Tobacco-2020 Crop Season from the slicer My result should be dispalyed as the second grid shown below.

Farmer Name	Region	Crop Season	CM season data	Gen profile 1
Dakshu	Mysore	KLS-Tobacco-2020	5	Tenth class
Dakshu	Mysore	KLS-Tobacco-2019	4	Tenth class
Kanna	Mysore	KLS-Tobacco-2020	3	Tenth class
Viyan	Mysore	KLS-Tobacco-2019	7	M.tech
Mahathi	Mysore			B.tech
Manoj	Mysore			M.tech
Surya	Mysore	KLS-Tobacco-2018		MBA

EXPECTED RESULT

Farmer Name	Region	Crop Season	CM season data	Gen profile 1
Dakshu	Mysore	KLS-Tobacco-2020	5	Tenth class
Kanna	Mysore	KLS-Tobacco-2020	3	Tenth class
Viyan	Mysore	KLS-Tobacco-2019	7	M.tech
Mahathi	Mysore			B.tech
Manoj	Mysore			M.tech
Surya	Mysore	KLS-Tobacco-2018		MBA

Is there any possiblity to achieve this if yes please let me know.

Thanks

Vannikannan.k

[v-jayw-msft]

Hi @Vannikannan ,

I don't quite understand the logic, are you want filter out Farmer has row with Crop Season is KLS-Tobacco-2020 but the current row is not KLS-Tobacco-2020?

Best Regards,

Jay

Community Support Team _ Jay Wang

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

[Vannikannan]

Hi Jay,

Thanks for reply,If I select the KLS-Tobacco-2020 from the slicer ,I have to get the result of following

1. All KLS-Tobacco-2020 farmers,
2. Farmer with No entries for Crop Season 
3. Farmer name of KLS-Tobacco-2019,2018(Viyan,Surya) etc records need to be dispalyed whereas the farmer with  KLS-Tobacco-2019,2018 Crop Season column should be dispalyed blank as mentioned in point 4 as the selected slicer is KLS-Tobacco-2020.

4. Farmer Name	Region	Crop Season	CM season data	Gen profile 1
   Daksu	Mysore	KLS-Tobacco-2020	5	Tenth class
   Kanna	Mysore	KLS-Tobacco-2020	3	Tenth class
   Viyan	Mysore			M.tech
   Mahathi	Mysore			B.tech
   Manoj	Mysore			M.tech
   Surya	Mysore			MBA

Is it possible to apply left join on the selection of slicer value to get the desired result or if any other possiblity please let me know.

Thanks 

Vannikannan

[amitchandak]

@Vannikannan , why 2019, 2018 and Mysore rows coming in expected output

[Vannikannan]

Hi Amithchandak,

Thanks for the reply.

If user select  KLS-Tobacco-2020 as the other user is also belong to the Crop season KLS-Tobacco should be dispalyed with blank crop season and CM Season Data as mentioned below. Viyan and Surya data should be dispalyed with blank cropseason and CM Season as it is not belong to the KLS-Tobacco-2020.

Kind of left join that we perform in Sql server is that possible in Power BI.

Farmer Name	Region	Crop Season	CM season data	Gen profile 1
Daksu	Mysore	KLS-Tobacco-2020	5	Tenth class
Kanna	Mysore	KLS-Tobacco-2020	3	Tenth class
Viyan	Mysore			M.tech
Mahathi	Mysore			B.tech
Manoj	Mysore			M.tech
Surya	Mysore			MBA

Thanks

Vannikannan.k