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
Anonymous
Not applicable

Filtering Line Chart multiple Values

Hello everyone,

 

I would like to make a filter to filter each of the values here. 

 

However I want to have the possibility to choose 2 of the 3 values as well in the same time.

 

I do not want to create 6-7 Bookmarks to do it, do you have an idea?

 

Thank you!

 

Ahmet

 

Ahmet_Oz_0-1615821670184.png

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hello guys,

 

I have solved the problem by adding a  new visual filter called : POWER KPI. 2:0

 

Thanks!

 

Ahmet

View solution in original post

6 REPLIES 6
Anonymous
Not applicable

Hello guys,

 

I have solved the problem by adding a  new visual filter called : POWER KPI. 2:0

 

Thanks!

 

Ahmet

v-luwang-msft
Community Support
Community Support

HI @Anonymous ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution to help others find it.
 
Best Regards
Lucien
 
v-luwang-msft
Community Support
Community Support

HI @Anonymous ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution to help others find it.
 
Best Regards
Lucien
 
amitchandak
Super User
Super User

@Anonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

Anonymous
Not applicable

Hello there,

 

I mean I would like to be able to filter these line charts values

 

Ahmet_Oz_0-1615824512647.png

 

 

For example: I am using the values below. I would like to be able to choose from the filter, which values should show or not. 
For example if i want to see:  only VALUE 1 and VALUE 3 , i would like to make it, and DO NOT see the VALUE 2.


Hope it clarifies 🙂 

 

Thanks!

 

Ahmet_Oz_1-1615824544047.png

 

 

 

 

@Anonymous , Take a measure slicer approach with a difference. Allow multi-select.

and create all measures like this

RAM Application new =
var _max = countx(filter(allselected(slicer), slicer[value] ="RAM"),slicer[value])
return
if(not(isblank(_max)),[RAM Application], blank())

 

 

Or use calculation groups. Refer examples of measure slicer(modify as suggested)  and calculation groups

 

measure slicer
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern


calculation groups

https://www.youtube.com/watch?v=vlnx7QUVYME

https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/

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.