Show Data Point Based on Slicer Selection

  • Published
  • Posted in General
  • Updated
  • 2 mins read

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 Gold Partner based in Mumbai, India, and a branch office in the U.S.

Addend has successfully implemented 100+ Microsoft Power BI and Business Central 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 or contacting us.

Email Us Or Contact Us