Hello readers, in this blog I will show, how to show the data points in a visual based on slicer selection.
Here is the view of the report,
In this view, all the values in the visual are from Sales table. Now, we want to have a slicer which has data points name and we want to show the selected data points in line visual.
Let’s get started…
Step 1: Create a slicer selection table using “Enter Data” feature.
Step 2: Create a slicer using “Selection” column from Slicer Selection table.
Step 3: Create measures for each data point. In this case, we have three data points i.e., Actuals, Forecast & Actuals PY.
Actuals TY = CALCULATE(SUM(Sales[Actual]),FILTER(Sales,CONTAINS(‘Slicer Selection’,’Slicer Selection'[Selection],”Actuals”)))
Forecast = CALCULATE(SUM(Sales[Forecast]),FILTER(Sales,CONTAINS(‘Slicer Selection’,’Slicer Selection'[Selection],”Forecast”)))
Actuals PY = CALCULATE([Previous Year Actual],FILTER(Sales,CONTAINS(‘Slicer Selection’,’Slicer Selection'[Selection],”Actuals PY”)))
Note: Keep the values parameter in CONTAINS same as in the “Selection” column’s value.
Step 4: Now, use the above measures in the visual
Now, you can select the data points you want to visualize from the Line Selection slicer on the top.
This is all about, showing the data points based on slicer selection.
I hope you will find this blog useful.
Gaurav Lakhotia
Data Analyst
Addend Analytics
Addend Analytics is a Microsoft Power BI Gold Partner based in Mumbai, India. Apart from being authorized for Power BI implementations, Addend has successfully executed Power BI projects for 100+ clients across sectors like Financial Services, Banking, Insurance, Retail, Sales, Manufacturing, Real estate, Logistics, and Healthcare in countries like the US, Europe, Switzerland, and Australia. Get a free consultation now by emailing us at kamal.sharma@addendanalytics.com or Contact us
