Forum Discussion
Vertical lines in a graph
- 6 years ago
Hi,
According to your description, i think your requirement can not be reached completely, but i have a workaround:
Please choose Line and Clustered Column Chart visual.
Then try this measure:
Measure = IF ( DISTINCTCOUNT ( 'Slicer Table'[Date] ) = BLANK () || DISTINCTCOUNT ( 'Slicer Table'[Date] ) = CALCULATE ( DISTINCTCOUNT ( 'Slicer Table'[Date] ), ALL ( 'Slicer Table' ) ), BLANK (), IF ( MIN ( 'Table'[Date] ) IN DISTINCT ( 'Slicer Table'[Date] ), MAXX ( CALCULATETABLE ( DISTINCT ( 'Table'[Date] ), ALLSELECTED ( 'Table'[Date] ) ), CALCULATE ( SUM ( 'Table'[Sales] ) ) ) ) )Create another seperate slicer table:
Slicer Table = SELECTCOLUMNS('Table',"Date",'Table'[Date])When choose one or more dates you want in slicer, the result shows:
You can also use another custom visual called Multiple Axes Chart - XViz :
The result shows:
Here is my test pbix file:
Hope this helps.
Best Regards,
Giotto Zhi
Hi,
According to your description, i think your requirement can not be reached completely, but i have a workaround:
Please choose Line and Clustered Column Chart visual.
Then try this measure:
Measure =
IF (
DISTINCTCOUNT ( 'Slicer Table'[Date] ) = BLANK ()
|| DISTINCTCOUNT ( 'Slicer Table'[Date] )
= CALCULATE ( DISTINCTCOUNT ( 'Slicer Table'[Date] ), ALL ( 'Slicer Table' ) ),
BLANK (),
IF (
MIN ( 'Table'[Date] ) IN DISTINCT ( 'Slicer Table'[Date] ),
MAXX (
CALCULATETABLE ( DISTINCT ( 'Table'[Date] ), ALLSELECTED ( 'Table'[Date] ) ),
CALCULATE ( SUM ( 'Table'[Sales] ) )
)
)
)Create another seperate slicer table:
Slicer Table = SELECTCOLUMNS('Table',"Date",'Table'[Date])When choose one or more dates you want in slicer, the result shows:
You can also use another custom visual called Multiple Axes Chart - XViz :
The result shows:
Here is my test pbix file:
Hope this helps.
Best Regards,
Giotto Zhi