Forum Discussion
Disable select all in segments
Hello,
I have a problem concerning segments, I created a sector segments and i disabled Select All and activated Unique Selection but the problem when i don't select any sector, automatiquelly it show me data for all sectors, is there a way to fix this ? i attached a picture to better explain
Thanks in advance
Anonymous ,
The table visual can't achieve your requirement. Please use card visual instead. Suppose the [National] is a measure, you can create a measure like below and drag the measure to the card visual:
Result = IF ( HASONEFILTER ( Table1[Secteur] ), MAX(Table1[National]), BLANK () )
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
- v-yuta-msftCommunity Support
Anonymous ,
You can modify your measure using DAX like pattern below and check if it can meet your requirement:
Result = IF ( HASONEFILTER ( Table[Selection] ), [National], BLANK () )
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- AnonymousNot applicable
v-yuta-msft I didn't understand well, could you more explain please ?
- AnonymousNot applicable
Any ideas ? Is it possible or not ?
- v-yuta-msftCommunity Support
Anonymous ,
The table visual can't achieve your requirement. Please use card visual instead. Suppose the [National] is a measure, you can create a measure like below and drag the measure to the card visual:
Result = IF ( HASONEFILTER ( Table1[Secteur] ), MAX(Table1[National]), BLANK () )
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.