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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
ompowerbi
Helper I
Helper I

Getting rid of "First" in a matrix visual

Hi, 

 

I want my matrix to not display anything in the "first sector" column when the matrix is not expanded. In the below example, the sector column would show nothing. 

ompowerbi_0-1688125466005.png

However, when expanded, it would show the respective sector for each city: 

ompowerbi_1-1688125582624.png

Essentially, when the matrix is not expanded, having "first sector" doesn't really make sense unless you see the city it is associated with. Is there anyway to change the visual / make a measure etc?
Thanks





1 ACCEPTED SOLUTION
lucadelicio
Super User
Super User

Hi, you have to find a way to return a different number in city/country.

A way could be to count the number of city. So when you are in the line of the country is > 1, when you are in the city line is one.
Something like this:
MEASURE =
var _count = DISTINCTCOUNT([City])
RETURN
IF(_count = 1, MAX([Sector], BLANK())

Mark as solution if i help you.

 

Ciao!

Luca D'Elicio

View solution in original post

3 REPLIES 3
ompowerbi
Helper I
Helper I

Thank you!

you're welcome

Luca D'Elicio
lucadelicio
Super User
Super User

Hi, you have to find a way to return a different number in city/country.

A way could be to count the number of city. So when you are in the line of the country is > 1, when you are in the city line is one.
Something like this:
MEASURE =
var _count = DISTINCTCOUNT([City])
RETURN
IF(_count = 1, MAX([Sector], BLANK())

Mark as solution if i help you.

 

Ciao!

Luca D'Elicio

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.