"dax "
2 TopicsLine Chart of Bins without Calculated Columns
I have a table 't_Devices' of columns [Device ID], [Date], [Input], [Output]. With Efficiency='t_Devices'[Input]/'t_Devices'[Output], I want to create a line chart of Efficiency Bins over time. To do that, I created calculated column of [Efficiency], then dummy calculated columns of [Is Efficiency In Bin 0-50], [Is Efficiency In Bin 50-100] based on [Efficiency], then a line chart of columns [Is Efficiency In Bin 0-50], [Is Efficiency In Bin 50-100], [Is Efficiency In Bin >100] over column [Date]. I want to ask whether is there any better way to create the line chart without creating a lot of dummy Bin columns because I have many bins in my real data. Thank you very much.SolvedHow to exclude a parameter filter/Name from one of my charts
Hi all, Power BI question I have situation where I have a pararameter set up param1 = { Name,nameof('dictionary'[Name]),0), { station,nameof('dictionary'[station]),1), { title,nameof('dictionary'[title),2) The parameter selection works and filter's as they should, however for the stacked column chart, I would like the Name parameter not to appear on the stacked bar chart and rather default to another default view on the bar chart. The reason for this when I click the name selection, I have over 300 names and that is an overwhelming look on the x-axis and has no use visualing for what i am trying to achieve. so below is a recreation of what i am workin on in Power BI. So when I select name on my drop down (powered by the parameter). I would like only the table to be affected by the change and the chart to ignore showing name as the x - axis dimension. so here if i selected name the table would list all the columns, but the chart would default and or stay in a view that shows thw count of stations by title. this is the view when station or Title is selected. Name does not appear on the table.