{"id":3893,"date":"2022-01-06T15:37:21","date_gmt":"2022-01-06T23:37:21","guid":{"rendered":"https:\/\/SUMMALAI.COM\/?p=3893"},"modified":"2022-01-06T15:37:22","modified_gmt":"2022-01-06T23:37:22","slug":"how-to-use-play-axis-to-show-line-graph-data-over-time-dynamically","status":"publish","type":"post","link":"https:\/\/SUMMALAI.COM\/?p=3893","title":{"rendered":"How to Use &#8220;Play Axis&#8221; to Show Line Graph Data Over Time Dynamically"},"content":{"rendered":"\n<p>There is a financial value plotted on a line graph over time from 2015 to 2019. The Date column is the First of the Month.&nbsp;<\/p>\n\n\n\n<p>If you want to use the play axis to do something to show this data dynamically, but is it possible to only have the data appear as the play axis runs through the months?<\/p>\n\n\n\n<p>The solution is as below:<\/p>\n\n\n\n<p>1. Create a&nbsp;<strong>separate<\/strong>&nbsp;table. No relationship between the two tables.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Table = DISTINCT('financials'&#91;Date])<\/code><\/pre>\n\n\n\n<p>2. Create a measure.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Measure = IF ( SELECTEDVALUE ( 'financials'&#91;Date] ) &lt; MIN ( 'Table'&#91;Date] ), 1, -1 )\n<\/code><\/pre>\n\n\n\n<p>3. Put the measure above in &#8220;Filters on this visual&#8221; of the line chart and filter it by &#8220;Measure is 1&#8221;.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/community.powerbi.com\/t5\/image\/serverpage\/image-id\/220426i884DD51F4F818FEB\/image-size\/large?v=v2&amp;px=999\" alt=\"play.PNG\" title=\"play.PNG\"\/><\/figure>\n\n\n\n<p>4. Put &#8220;Date&#8221; column from &#8220;Table&#8221; in Play Axis.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/community.powerbi.com\/t5\/image\/serverpage\/image-id\/220427i084F4458EFEC403E\/image-size\/large?v=v2&amp;px=999\" alt=\"PLAY.jpg\" title=\"PLAY.jpg\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/community.powerbi.com\/t5\/image\/serverpage\/image-id\/220429iECAE848C175EC25C\/image-size\/large?v=v2&amp;px=999\" alt=\"play axis 1.gif\" title=\"play axis 1.gif\"\/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>There is a financial value plotted on a line graph over time from 2015 to 2019. The Date column is the First of the Month.&nbsp; If you want to use the play axis to do something to show this data dynamically, but is it possible to only have the data appear as the play axis <a class=\"read-more\" href=\"https:\/\/SUMMALAI.COM\/?p=3893\">Read More<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[10,621],"tags":[1023,1024],"class_list":["post-3893","post","type-post","status-publish","format-standard","hentry","category-microsoft","category-power-bi","tag-play-axis","tag-play-axis-power-bi"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/3893","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3893"}],"version-history":[{"count":3,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/3893\/revisions"}],"predecessor-version":[{"id":3913,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/3893\/revisions\/3913"}],"wp:attachment":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3893"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3893"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3893"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}