Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hi,
I have two data sets, that have Date fields, I have created a relationship between "Start of Month" & "Start of Week", as the Start of month is the active relationship the data is not changing in the Visuals of Voice data.
Also, I have created measure to convert seconds to HH:MM:SS, which has to be filtered when I select the month slicer.
Relationship:
Slicers in the report:
Hi @Sri_phani ,
I would recommend using a separate date table and relating it to both of those tables. Use fields from the date table for your slicers. Here is some additional information on date tables:
https://www.datacamp.com/tutorial/how-to-create-date-tables-in-power-bi-tutorial
https://www.sqlbi.com/articles/creating-a-simpler-and-chart-friendly-date-table-in-power-bi/
User | Count |
---|---|
13 | |
8 | |
8 | |
7 | |
5 |
User | Count |
---|---|
21 | |
15 | |
15 | |
10 | |
7 |