Forum Discussion
Slicer single selection in a tree
Hi,
Any body can help me with this issue:
I need to select only one item in a slicer with a tree as figure below
When i select "ANT"
both dates are selected automatically, but i just want to have one (the slicer date is configured as single selection).
Is there a solution for this?
Here is my provisory solution:
Created a measure: condicao descargas = if(or('Medidas'[Sigla Selecionada]="ABO",'Medidas'[soma contador descargas]>max('BD Descargas'[Contador Rama])),"Selecionar Descarga","Gerar Relatório")
to modify a button text like this:
The condition is based on the created measure:
An the result is:
The text varies depending on the condition of the measure created.
This solution was based on readings on other foruns from users of powerBi but has a little bit of my hand.As I said before this is not a bullet proof solution, but for now that what we have.
Regards
5 Replies
- themistoklis
Community Champion
Turn off single select and turn on Multi-select with CTRL
Then on Filter do not select the upper level (e.g. Americas, but directly select the lower level values e.g. 'Aruba', 'Bahamas'... and for multiple selection hold the control button
This solution is not acceptable since i still need to select one and only one object.
Regards
Here is my provisory solution:
Created a measure: condicao descargas = if(or('Medidas'[Sigla Selecionada]="ABO",'Medidas'[soma contador descargas]>max('BD Descargas'[Contador Rama])),"Selecionar Descarga","Gerar Relatório")
to modify a button text like this:
The condition is based on the created measure:
An the result is:
The text varies depending on the condition of the measure created.
This solution was based on readings on other foruns from users of powerBi but has a little bit of my hand.As I said before this is not a bullet proof solution, but for now that what we have.
Regards
- amitchandak
Super User
ALWP , I doubt that is possible.
I'm sorry but that is an answer that not cannot accept. If that is not possible to do in the moment (hope it will be in future) for now there is/are ways to workaround this issue.
I find one but its not bullet proof.
I 'm continue to search a way that keep my report secure without given false information to users
Thanks anyway
