"slicer"

4 Topics

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
Solved
Madhu7624
1 year ago Place DAX Commands and Tips
1.3KViews
0likes
4Comments
Chart Granularity
I have a graph that shows the Offered, Answered & Abandoned calls from my data set. I have this on the y-axis of a bar chart and then I have created a parameter for the dates on the x-axis. This allows me to use a slicer to swap between the granularity levels (Daily, Weekly, Monthly).To achieve this, I have a date table that has all the dates for this year, along with a column defining the month and a column defining the week commencing date. I want the Daily view to show the last 30 days, the weekly view to show the last 8 weeks and the monthly view to show the last 12 months. This is where I am running into an issue. I can't get the dates to change with the granularity which causes my data to show an entire year of data on all the views. How can I change this so the date range of the displayed data aligns with the desired granularity that is being set by the slicer?
Solved
Diabetic
1 year ago Place DAX Commands and Tips
801Views
0likes
2Comments
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, Abhiram
abhiram342
2 years ago Place DAX Commands and Tips
417Views
0likes
1Comment
Need a measure to count total customers/sales while making a slicer count as AND, not OR.
I have 3 tables. Sales is a list of sales, including a unique Sale ID. Customers is a list of customers for each sale, linked to Sales via Sale ID in a both ways many to one relationship (a single sale can have multiple customers). Conditions is a table of conditions for each sale, also linked to Sales via Sale ID in a both ways many to one relationship (a single sale can have multiple conditions). I would like to create two measures: one to track the total number of sales, and one to track the total number of customers. This part is easy. However, I would like to include the Conditions table as a slicer for this data. I want this slicer to work on AND logic, rather than OR logic. If I click conditions A and B on the slicer, I want my measures to count the total number of sales/customers which are classed as condition A and B, not A or B. I have not succeeded at this. I tried installing the custom visual Smart Filter Pro, but for some idiotic reason Power BI doesn't even show the icon for it. I tried several online solutions, like POWER BI SLICER WITH "AND CONDITION" TO FILTER STACKED BAR CHART FOR MULTIPLE ITEMS - Ruki's Blog (rukiatu.com) (didn't work, just gave me the OR totals as normal), Slicer with AND condition in Power BI - RADACAD (didn't work, told me it couldn't find the Conditions table or there wasn't a relationship detected, absolutely wrong but whatever), and Solved: Filtering a Multi-Select Slicer via AND instead of... - Microsoft Fabric Community (didn't work, when I tried to apply two slicers I got "An unexpected error occurred (file mdformula.h, line 615, function 'ValueTypeFromXLSubType')."). So now I come to you. Would you be able to help?
Solved
Singularity9
3 years ago Place DAX Commands and Tips
1KViews
0likes
1Comment