Forum Discussion
Filter Datas
Ola, alguem poderia me ajudar com minha duvida?
Tenho diversas colunas de dados no meu formulario, por exemplo, dados de criacao da solicitacao e data agendada, no meu dashboard, gostaria de poder alterar a visualizacao dos dados entre esses dois dados, por exemplo, se eu clicar em um, ele extrai como dados da "data de criacao" e se eu clicar no outro filtro, ele puxa a coluna "data agendada" coluna, existe uma maneira de fazer isso? nao encontrei em lugar nenhum
1 Reply
Hi CarlosAfonso ,
You can use the bookmarks and buttons feature in Power BI to switch between different views (visibility).
Set up two views for the data in the report: one using the creation date and the other using the scheduled date. Create two bookmarks to save the visual visibility state. Insert two buttons in the report, each corresponding to a date type. Select the appropriate bookmark for each button. When clicking each button, the report should switch to the view using the other date column.
Create report bookmarks in Power BI to share insights and build stories
Not sure how you constructed your data model, if possible try using the USERELATIONSHIP() function.
Using USERELATIONSHIP in DAX - SQLBIBest Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum -- China Power BI User Group
