CODEWITHSUNDEEP
powerbi
Ayelet
Ayelet

Reputation: 31

Is there a way to do dashed line in Power BI?

I want to create a line chart on Power BI, grouped by months, that update every day. I want to have a dashed line only in the unfinished month, to show that the data is not full.

I have a table with daily bookings. I want to create a line graph on Power BI, that axis x will be month-year. The current month will be dashed and will include only the data since the first of the current month.

Upvotes: 1

Views: 17813

Answers (1)

Jon
Jon

Reputation: 4967

There isn't a direct way in Power BI to do this, the closest that you can get to is to create the same measure twice to fake it. You'll need a way to identify the latest months data for a filter. In the example that I have done, one measure is

Full Months = CALCULATE(SUM('MyTable'[Value]), FILTER('MyTable', 'MyTable'[Current] = 0))

and the other one is Value = SUM('MyTable'[Value])

What I have done is show two measures, one on top of the other. You can update the chart formatting and select the 'Shapes' option' and select 'Customise series' and then select the measure name, and format as such.

enter image description here

You can set the legend to Off, and it will show like its one value.

Upvotes: 1

Related Questions