{"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":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.9 - aioseo.com -->\n\t<meta name=\"description\" content=\"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. 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\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Summa Lai\"\/>\n\t<meta name=\"keywords\" content=\"play axis,play axis power bi,microsoft family,power bi\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/SUMMALAI.COM\/?p=3893\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.9\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?p=3893#article\",\"name\":\"How to Use \\u201cPlay Axis\\u201d to Show Line Graph Data Over Time Dynamically | Summa Lai\",\"headline\":\"How to Use &#8220;Play Axis&#8221; to Show Line Graph Data Over Time Dynamically\",\"author\":{\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?author=2#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/#person\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/community.powerbi.com\\\/t5\\\/image\\\/serverpage\\\/image-id\\\/220426i884DD51F4F818FEB\\\/image-size\\\/large?v=v2&amp;px=999\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?p=3893\\\/#articleImage\"},\"datePublished\":\"2022-01-06T15:37:21-08:00\",\"dateModified\":\"2022-01-06T15:37:22-08:00\",\"inLanguage\":\"en-US\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?p=3893#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?p=3893#webpage\"},\"articleSection\":\"Microsoft Family, Power BI, Play Axis, Play Axis Power BI\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?p=3893#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/SUMMALAI.COM\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?cat=10#listItem\",\"name\":\"Microsoft Family\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?cat=10#listItem\",\"position\":2,\"name\":\"Microsoft Family\",\"item\":\"https:\\\/\\\/SUMMALAI.COM\\\/?cat=10\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?cat=621#listItem\",\"name\":\"Power BI\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?cat=621#listItem\",\"position\":3,\"name\":\"Power BI\",\"item\":\"https:\\\/\\\/SUMMALAI.COM\\\/?cat=621\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?p=3893#listItem\",\"name\":\"How to Use &#8220;Play Axis&#8221; to Show Line Graph Data Over Time Dynamically\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?cat=10#listItem\",\"name\":\"Microsoft Family\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?p=3893#listItem\",\"position\":4,\"name\":\"How to Use &#8220;Play Axis&#8221; to Show Line Graph Data Over Time Dynamically\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?cat=621#listItem\",\"name\":\"Power BI\"}}]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/#person\",\"name\":\"sladmin\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?p=3893#personImage\",\"url\":\"https:\\\/\\\/SUMMALAI.COM\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Summa_Logo-150x150.png\",\"width\":96,\"height\":96,\"caption\":\"sladmin\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?author=2#author\",\"url\":\"https:\\\/\\\/SUMMALAI.COM\\\/?author=2\",\"name\":\"Summa Lai\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?p=3893#authorImage\",\"url\":\"https:\\\/\\\/SUMMALAI.COM\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Summa_Logo-150x150.png\",\"width\":96,\"height\":96,\"caption\":\"Summa Lai\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?p=3893#webpage\",\"url\":\"https:\\\/\\\/SUMMALAI.COM\\\/?p=3893\",\"name\":\"How to Use \\u201cPlay Axis\\u201d to Show Line Graph Data Over Time Dynamically | Summa Lai\",\"description\":\"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. 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\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?p=3893#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?author=2#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/?author=2#author\"},\"datePublished\":\"2022-01-06T15:37:21-08:00\",\"dateModified\":\"2022-01-06T15:37:22-08:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/#website\",\"url\":\"https:\\\/\\\/SUMMALAI.COM\\\/\",\"name\":\"Summa Lai\",\"description\":\"Never Stop Learning, Building a Little Wiki...\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/SUMMALAI.COM\\\/#person\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"How to Use \u201cPlay Axis\u201d to Show Line Graph Data Over Time Dynamically | Summa Lai","description":"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. 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","canonical_url":"https:\/\/SUMMALAI.COM\/?p=3893","robots":"max-image-preview:large","keywords":"play axis,play axis power bi,microsoft family,power bi","webmasterTools":{"miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/SUMMALAI.COM\/?p=3893#article","name":"How to Use \u201cPlay Axis\u201d to Show Line Graph Data Over Time Dynamically | Summa Lai","headline":"How to Use &#8220;Play Axis&#8221; to Show Line Graph Data Over Time Dynamically","author":{"@id":"https:\/\/SUMMALAI.COM\/?author=2#author"},"publisher":{"@id":"https:\/\/SUMMALAI.COM\/#person"},"image":{"@type":"ImageObject","url":"https:\/\/community.powerbi.com\/t5\/image\/serverpage\/image-id\/220426i884DD51F4F818FEB\/image-size\/large?v=v2&amp;px=999","@id":"https:\/\/SUMMALAI.COM\/?p=3893\/#articleImage"},"datePublished":"2022-01-06T15:37:21-08:00","dateModified":"2022-01-06T15:37:22-08:00","inLanguage":"en-US","mainEntityOfPage":{"@id":"https:\/\/SUMMALAI.COM\/?p=3893#webpage"},"isPartOf":{"@id":"https:\/\/SUMMALAI.COM\/?p=3893#webpage"},"articleSection":"Microsoft Family, Power BI, Play Axis, Play Axis Power BI"},{"@type":"BreadcrumbList","@id":"https:\/\/SUMMALAI.COM\/?p=3893#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/SUMMALAI.COM#listItem","position":1,"name":"Home","item":"https:\/\/SUMMALAI.COM","nextItem":{"@type":"ListItem","@id":"https:\/\/SUMMALAI.COM\/?cat=10#listItem","name":"Microsoft Family"}},{"@type":"ListItem","@id":"https:\/\/SUMMALAI.COM\/?cat=10#listItem","position":2,"name":"Microsoft Family","item":"https:\/\/SUMMALAI.COM\/?cat=10","nextItem":{"@type":"ListItem","@id":"https:\/\/SUMMALAI.COM\/?cat=621#listItem","name":"Power BI"},"previousItem":{"@type":"ListItem","@id":"https:\/\/SUMMALAI.COM#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/SUMMALAI.COM\/?cat=621#listItem","position":3,"name":"Power BI","item":"https:\/\/SUMMALAI.COM\/?cat=621","nextItem":{"@type":"ListItem","@id":"https:\/\/SUMMALAI.COM\/?p=3893#listItem","name":"How to Use &#8220;Play Axis&#8221; to Show Line Graph Data Over Time Dynamically"},"previousItem":{"@type":"ListItem","@id":"https:\/\/SUMMALAI.COM\/?cat=10#listItem","name":"Microsoft Family"}},{"@type":"ListItem","@id":"https:\/\/SUMMALAI.COM\/?p=3893#listItem","position":4,"name":"How to Use &#8220;Play Axis&#8221; to Show Line Graph Data Over Time Dynamically","previousItem":{"@type":"ListItem","@id":"https:\/\/SUMMALAI.COM\/?cat=621#listItem","name":"Power BI"}}]},{"@type":"Person","@id":"https:\/\/SUMMALAI.COM\/#person","name":"sladmin","image":{"@type":"ImageObject","@id":"https:\/\/SUMMALAI.COM\/?p=3893#personImage","url":"https:\/\/SUMMALAI.COM\/wp-content\/uploads\/2020\/05\/Summa_Logo-150x150.png","width":96,"height":96,"caption":"sladmin"}},{"@type":"Person","@id":"https:\/\/SUMMALAI.COM\/?author=2#author","url":"https:\/\/SUMMALAI.COM\/?author=2","name":"Summa Lai","image":{"@type":"ImageObject","@id":"https:\/\/SUMMALAI.COM\/?p=3893#authorImage","url":"https:\/\/SUMMALAI.COM\/wp-content\/uploads\/2020\/05\/Summa_Logo-150x150.png","width":96,"height":96,"caption":"Summa Lai"}},{"@type":"WebPage","@id":"https:\/\/SUMMALAI.COM\/?p=3893#webpage","url":"https:\/\/SUMMALAI.COM\/?p=3893","name":"How to Use \u201cPlay Axis\u201d to Show Line Graph Data Over Time Dynamically | Summa Lai","description":"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. 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","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/SUMMALAI.COM\/#website"},"breadcrumb":{"@id":"https:\/\/SUMMALAI.COM\/?p=3893#breadcrumblist"},"author":{"@id":"https:\/\/SUMMALAI.COM\/?author=2#author"},"creator":{"@id":"https:\/\/SUMMALAI.COM\/?author=2#author"},"datePublished":"2022-01-06T15:37:21-08:00","dateModified":"2022-01-06T15:37:22-08:00"},{"@type":"WebSite","@id":"https:\/\/SUMMALAI.COM\/#website","url":"https:\/\/SUMMALAI.COM\/","name":"Summa Lai","description":"Never Stop Learning, Building a Little Wiki...","inLanguage":"en-US","publisher":{"@id":"https:\/\/SUMMALAI.COM\/#person"}}]}},"aioseo_meta_data":{"post_id":"3893","title":null,"description":null,"keywords":[],"keyphrases":{"focus":[],"additional":[]},"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":"","og_custom_url":null,"og_article_section":null,"og_article_tags":[],"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":{"id":"#aioseo-article-65a0cd18d205e","slug":"article","graphName":"Article","label":"Article","properties":{"type":"BlogPosting","name":"#post_title","headline":"#post_title","description":"#post_excerpt","image":"","keywords":"","author":{"name":"#author_name","url":"#author_url"},"dates":{"include":true,"datePublished":"","dateModified":""}}},"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"Article","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":"{\"article\":{\"articleType\":\"BlogPosting\"},\"course\":{\"name\":\"\",\"description\":\"\",\"provider\":\"\"},\"faq\":{\"pages\":[]},\"product\":{\"reviews\":[]},\"recipe\":{\"ingredients\":[],\"instructions\":[],\"keywords\":[]},\"software\":{\"reviews\":[],\"operatingSystems\":[]},\"webPage\":{\"webPageType\":\"WebPage\"}}","pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":"-1","robots_max_videopreview":"-1","robots_max_imagepreview":"large","priority":null,"frequency":"default","local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2021-12-31 07:26:12","updated":"2024-01-12 05:24:40","seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/SUMMALAI.COM\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/SUMMALAI.COM\/?cat=10\" title=\"Microsoft Family\">Microsoft Family<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/SUMMALAI.COM\/?cat=621\" title=\"Power BI\">Power BI<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tHow to Use \u201cPlay Axis\u201d to Show Line Graph Data Over Time Dynamically\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/SUMMALAI.COM"},{"label":"Microsoft Family","link":"https:\/\/SUMMALAI.COM\/?cat=10"},{"label":"Power BI","link":"https:\/\/SUMMALAI.COM\/?cat=621"},{"label":"How to Use &#8220;Play Axis&#8221; to Show Line Graph Data Over Time Dynamically","link":"https:\/\/SUMMALAI.COM\/?p=3893"}],"_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}]}}