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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
Syndicate_Admin
Administrator
Administrator

"Inverted" Segmenter

Is it possible that, by default, a chart appears empty until one option (or more) is selected in a segmenter?

1 ACCEPTED SOLUTION

Hi @Syndicate_Admin 
Please refer to my linked PBIX.

Ritaf1983_0-1701716136565.pngRitaf1983_1-1701716280439.png

 


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

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

15 REPLIES 15
Syndicate_Admin
Administrator
Administrator

What I intended, which I suppose is not possible, is to use two different segmenters: one with the 10 most common substyles, and one with the rest. In this way, the user can quickly access the top 10 and, if they wish, can compare them with others on the list of the least common. And also that the graph appears empty at first to avoid an overload of lines.

Syndicate_Admin
Administrator
Administrator

Well, what you see in the photo, there is always a gray line corresponding to that sub-style, "Electropop", although the one that has been marked is a different one.

Syndicate_Admin
Administrator
Administrator

By the way, why do you press the style that you press always get a gray basal line corresponding to "Electropop"?

javier_blanco_0-1702058312409.png

Sorry, I don't understand what are you trying to achieve.

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile
Syndicate_Admin
Administrator
Administrator

Would it be possible to manage the graph with both segmenters at the same time? Mark one substyle in the first and another in the second and have both visible in the chart.

@Syndicate_Admin 
Please show what you mean.

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Hi @Syndicate_Admin 
It didn't work because you used the same table for the graph and the slicer.
is filtered on the graph in this scenario is always 1, because of the legend filtering the values.
You should add dimension for the slicer with unique values.

Ritaf1983_0-1702007156108.png

Use it only for the slicer

On the graph use your original table.

Ritaf1983_1-1702007289562.pngRitaf1983_2-1702007520724.png

update the dax for the filter to :

subestilo_filtrado = INT(ISFILTERED('Table for slicer'[nombre_subestilo]))
The pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile
Syndicate_Admin
Administrator
Administrator

It gives me this error message when trying to attach the .pbix:

javier_blanco_0-1701881889268.png

Hi @Syndicate_Admin 
Save the pbix in one drive or something like that and share the link

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile
Syndicate_Admin
Administrator
Administrator

Yes, I see that it works, and that in the YouTube video as well. The problem is that in my data model it doesn't, and I don't understand why.

Hi @Syndicate_Admin 
Please share a link to your dummy pbix.
I don't think that it is possible to understand what is going wrong without looking at it.

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile
Syndicate_Admin
Administrator
Administrator

What I'm trying to do is a bit more complicated, but I've replicated the video example as a test and it doesn't work for me:

The table I'm starting from:

javier_blanco_0-1701713143320.png

The measure that is used as a filter:

javier_blanco_1-1701713176991.png

The result of filtering:

javier_blanco_2-1701713255440.png

As you can see, all the values keep appearing.

Ritaf1983
Super User
Super User

Hi @Syndicate_Admin 
Yes, you can create a flag measure for selections and filter the graphs by it.

Please refer to the tutorial:

https://www.youtube.com/watch?v=sXn-QZqLD-8

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

 

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Hi @Syndicate_Admin 
Please refer to my linked PBIX.

Ritaf1983_0-1701716136565.pngRitaf1983_1-1701716280439.png

 


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

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.