Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi,
I have a slicer name "6H Only" which the chart displays the last 6 hours of data when I click on it. When not clicked on the slicer the chart displays the last 24 hours of data but slicer still displays "6H Only". Is there a way for the slicer to display "24 Hours" as text on it when it is not selected ?
Thank you
Yes I tried with the second slicer "24 Hours" but I guess slicers doesn't act like buttons that I can do the toggle switch between these 2 slicers.
Did you mean a second slicer? Or did you try an additional value in the same slicer? Can you share a screenshot of your model?
Yes second slicer displaying the last 24 hours. There is a dax behind the slicer which filters the chart. when the slicers not selected it displays the last 24 hours anyway. so I dont really need the 2nd (the last 24 hours ) I guess.
Oh, so there isn't a relationship between your dimension that holds the slicer values and your fact table? Instead you're filtering within the DAX measure in the table based on the selected value of the slicer? Well... you can conditionally format the title of a slicer, so you could have that change depending on the selection. But you would still have text inside the slicer button. You could get around this by replacing the value of "6H Only" to be an empty character so text wouldn't show up in the button.
I don't think you can do this as the text on the slicer button is the value from the table, and you cannot conditionally format it. Have you considered adding a second slicer value, "24 Hours," so that there are two buttons, effectively creating a toggle switch.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
75 | |
63 | |
51 | |
48 |
User | Count |
---|---|
204 | |
86 | |
64 | |
59 | |
56 |