Define starting date on a graph, defined by Project (Slicer)

[rokacl]

Hi There,

I´m new at PBI, so lets go... I´m trying to make a graph that start when the selected project (Edificio Montt) opened it show room (08-18), so I can count how may periods from it started till the first sales and rest, and finally, if there is a month without sales, I need the graph to show the month.

I have a Dim Table with the static data from the project, and other Fact Table with the sales by day, I have many projects,

Thanks.

[AllisonKennedy]

Do you have a dim table for DATE as well or just for project info? If you don't have a DimDate table yet, that is the first step in helping to solve your problem. Please let us know if you have this already or not so we know how to advise you.

[rokacl]

Yes, I have a dimtable for date, is a calendar table that start with the date of the first opened show room, and ends with today(), 

[AllisonKennedy]

I can think of two options off the top of my head:

1) Use the 'show items with no data' option to expand the date range in the graph. This will show all dates starting from the first date of the first project.

2) Since column charts don't currently allow you to use a measure to define the starting axis, we can cheat the system and use a combo chart to change which dates are displayed. Create a new measure to dictate which dates are shown. Depending on the answers to your questions below, this measure might look something like: 

DatesToShow = CALCULATE(COUNTROWS(FILTER('Calendar',[ProjectStart]<'Calendar'[Date])))

Then format the combo chart to make the line values the same colour as background and turn off secondary y-axis.

Questions:

How have you gotten the primera fecha venta 08-18? Is that a defined DAX measure?

Can you send a screenshot of your model view so we can see the relationships, or answer these questions: Based on which date field (I'm guessing it is in the project not the sales table)? Which columns are used to relate the Date table to the Fact sales table? Is the Project table related to the Date table?

[rokacl]

Thank you for the answer, I´m gonna try that

About your question 

How have you gotten the primera fecha venta 08-18? Is that a defined DAX measure? Actually is a static date in a dim table with basic information of each project, one row per project. ('Stock en UF y Pesos'[Inicio Ventas])

This is my model:

1) I make a slicer to select project using projects described in 'Stock en UF y Pesos'[Proyecto]

2) I make a graph using 'Tabla Calendario'[Date] as X-Axis, and 'Cotizaciones'[Total] as Y-Axis, so I have the total amount of leads between dates (visually I can make the visualization since the first lead to the last, or showing the whole range of dates with no info), but I´m not able to start the graph with the date defined in 'Stock en UF y Pesos'[Inicio Ventas]