cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

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

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.

 

Captura.JPG

 
 
4 REPLIES 4
Highlighted
Community Champion
Community Champion

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

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.

 


______________


Has this post solved your problem? Please mark it as a solution so that others can find it quickly and to let the community know your problem has been solved. 


If you found this post helpful, please give Kudos.


I work as a trainer and consultant for Microsoft 365, specialising in Power BI and Power Query. 


https://sites.google.com/site/allisonkennedycv

Highlighted
Helper I
Helper I

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

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(), 

Highlighted
Community Champion
Community Champion

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

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?

 


______________


Has this post solved your problem? Please mark it as a solution so that others can find it quickly and to let the community know your problem has been solved. 


If you found this post helpful, please give Kudos.


I work as a trainer and consultant for Microsoft 365, specialising in Power BI and Power Query. 


https://sites.google.com/site/allisonkennedycv

Highlighted
Helper I
Helper I

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

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]

 

 

model.JPG

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors
Top Kudoed Authors