1.0Xelplus - Leila Gharanihttps://www.xelplus.comLeila Gharanihttps://www.xelplus.com/author/xelplus/rich600338<blockquote class="wp-embedded-content" data-secret="XsmtTTnKtu"><a href="https://www.xelplus.com/excel-interactive-dashboard-trick-dax/">How to Include Measures (or KPIs) inside Slicers – Excel Interactive Dashboard Trick</a></blockquote><iframe sandbox="allow-scripts" security="restricted" src="https://www.xelplus.com/excel-interactive-dashboard-trick-dax/embed/#?secret=XsmtTTnKtu" width="600" height="338" title="“How to Include Measures (or KPIs) inside Slicers – Excel Interactive Dashboard Trick” — Xelplus - Leila Gharani" data-secret="XsmtTTnKtu" frameborder="0" marginwidth="0" marginheight="0" scrolling="no" class="wp-embedded-content"></iframe><script> /*! This file is auto-generated */ !function(d,l){"use strict";l.querySelector&&d.addEventListener&&"undefined"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!/[^a-zA-Z0-9]/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret="'+t.secret+'"]'),o=l.querySelectorAll('blockquote[data-secret="'+t.secret+'"]'),c=new RegExp("^https?:$","i"),i=0;i<o.length;i++)o[i].style.display="none";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute("style"),"height"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):"link"===t.message&&(r=new URL(s.getAttribute("src")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener("message",d.wp.receiveEmbedMessage,!1),l.addEventListener("DOMContentLoaded",function(){for(var e,t,s=l.querySelectorAll("iframe.wp-embedded-content"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute("data-secret"))||(t=Math.random().toString(36).substring(2,12),e.src+="#?secret="+t,e.setAttribute("data-secret",t)),e.contentWindow.postMessage({message:"ready",secret:t},"*")},!1)))}(window,document); </script> https://www.xelplus.com/wp-content/uploads/2021/09/blogicon_PivotTableSlicerDAX_gradient.jpg800450With Pivot Charts in Microsoft Excel, you can add slicers to add interactive functionality to your dashboards. But what about adding even more interactivity? You could give the user the ability to change the relevant KPI in the chart from the slicer. You just need a tiny bit of DAX.