Only show Y-Axis if Splicer selection activated
Hello, I am wondering if there is a way to only show a Y-Axis line on a line and stacked column chart if a Slicer filter is activated. Screenshots below ↓↓ 1. Is the chart when nothing in my slicer is selected (This is where I would like the Y-axis line to not appear) 2. Chart when Bin is selected on slicer (where I would like the Y-axis to then show up) Any help would be greatly appreciated. Thanks! Jeremy B.
Line & Stacked Column - Show column segments as percentage of line
Hi, Perhaps super easy for some. I have a line (Total Income for the year) and I have the stacked column representing expenses for that year. I'd like to have the segments of the stacked column show the percentage of the total income in that year. That's the first issue. Secondly, the example I'm using is a farmer, however I'll have other industries where different components will be represented in the column. Will that require a new DAX command for every important column component in every clients Power BI file? TIA, Justin
