Sorting Matrix Data Based on Slicer Selection
Hi Everyone, I want to sort the data in a matrix in a specific order. When I select a value in the slicer. Below is the raw data: The matrix visual contains Product and Value [Measure]. Raw Data Slicer The order in which the products need to be sorted depends on the year value selected in the slicer. Raw Data : Table Product Year Value P3 2023 100 P2 2023 200 P1 2023 300 P8 2023 40 P6 2023 100 P1 2024 200 P3 2024 300 P2 2024 40 P14 2024 100 P12 2024 200 slicer : Year 2023 2024 Required order, when we click on slicer : Order Required 2023 2024 Order order P1 P1 P2 P2 P3 P3 P6 P12 P8 P14
Pass selected slicer value(Text) into a measure
Hi, *I'm using Report Server Desktop "RS". I have a slicer that shows text values instead of numbers. I would like to create a measure that takes the selected "text"value(Column A) in a slicer, filters Column B based on the selected value in Column A. Then returns a "count" or "distinct count" of the filtered rows. I tried building a measure but I'm returned with a message "Cannot convert value XXXX of type Text to type Number". This seems like a simple formula but I'm not using the right syntax for DAX. Heres a table example: Column A-Slicer filters on this column Dog Cat Mouse Horse Column B PitBull Corgi Tabby Cat Jack Russell Thank you
How to filter Parent ID only in child-parent Hierarchy slicer
Hi All, I have table with Pipelines and Activities. However, In Pipelines Table, I have ParentPipeline and When I select ParentName, data should filter only to specific parent and don't filter childs. Also, When I filter specifc Child, it should filter data for specific child and shouldn't filter parent. Can you please help how to achieve it? Should I need to redesign Pipelines Table? Pipelines: Activities: Pipelines ( PipelineID) 1 --> Activites (*)(PipelineId) ( 1 to Many) Issue: When I select ParentName as "Process" Or ParentPipelineID as "B", It should display rows for PipelineID == B but below screenshot display data for child i.e C & D. Please suggest how to display data for ParentPipelineID only i.e PipelineID == B Thanks, AbhiramSaving filter selections per user in Report Server
Hi All I have a report in Report Server and it contains a filter pop-up containing many slicers. My users would like the system to remember the last value on applied slicers so they won't need to apply then again when they open the report next time. Doesn't PowerBI use cookies for that? If not, what solution world you recommend? Thank youDate slicer is not changing date when selecting other slicer
Hello all, We're trying to desing a dashboard in which we have 2 slicers: 1) Date slicer with between option 2) Mosaic slicer in which I can select the Department. The thing is that as you can see, first date od data set is 01/01/2022 but I want that when I select a Department, the date of Date Slicer changes also. But this doesn't happens and this feature/bug is just present on this kind of slicer. If I try it with other Date Slicer it works. Do you know if there is any way to perform this but with first slicer showed? Thans a lot in advance
