Forum Discussion
power bi Service
Dear all ,
what if i have published a report and my user wants to visulaize reports in his own way for example i give him a selection date slicer , and name of subject and name of student in a drop down ,
then when he selects all filter only then data will be shown on matrix , untill then matrix will be empty , is there any way of doing it , i appreciate your valuable time , thanks
Sujit_Thakur
You can do it by creating a measure that checks if these three slicers are selected, then, adjust the visibility of the matrix by overlaying it with card visual and adjusting the fill color based on conditional formating.
Please check the attached file, I solved a similar issue.You can download the file: HERE
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply 🙂
From the May 2020 release of Power BI Desktop there is a preview feature "Personalize visuals" If you enable this feature your users will be able to change and personalize the reports you share with them.
See https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-personalize-visuals
Hope this helps
Stuart
4 Replies
Sujit_Thakur
You can do it by creating a measure that checks if these three slicers are selected, then, adjust the visibility of the matrix by overlaying it with card visual and adjusting the fill color based on conditional formating.
Please check the attached file, I solved a similar issue.You can download the file: HERE
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply 🙂
Thanks Fowmy
From the May 2020 release of Power BI Desktop there is a preview feature "Personalize visuals" If you enable this feature your users will be able to change and personalize the reports you share with them.
See https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-personalize-visuals
Hope this helps
Stuart
thanks Burningsuit
